What's new in Customer Journeys?

Connect and learn more!
GET_PAYROLL_PERIOD Get function not returning value — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

GET_PAYROLL_PERIOD Get function not returning value

Received Response
19
Views
1
Comments

Summary:

Default for PER_ASG_REL_ACTUAL_TERMINATION_DATE is '0001/01/01 00:00:00' (date)


ld_effective_date= GET_CONTEXT(EFFECTIVE_DATE,'4712/12/31 00:00:00'(date))

ld_term_date = PER_ASG_REL_ACTUAL_TERMINATION_DATE

ld_payroll_id = GET_CONTEXT(PAYROLL_ID, 0)


l_debug= ESS_LOG_WRITE('ldpayroll_id is: '|| to_char(ld_payroll_id))


CHANGE_CONTEXTS(PAYROLL_ID = ld_payroll_id)

(

E = GET_PAYROLL_PERIOD(ld_effective_date)


l_pay_period_sd = GET_DATE('PAYROLL_PERIOD_START_DATE')


l_pay_period_ed = GET_DATE('PAYROLL_PERIOD_END_DATE')


)


enrollmentEndDate = ld_effective_date


l_debug= ESS_LOG_WRITE('ld_term_date is: '|| to_char(ld_term_date))

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!