DBA Data[Home] [Help]

APPS.PAY_YEAR_END_EXTRACT dependencies on HR_GENERAL

Line 442: substr(HR_GENERAL.DECODE_LOOKUP('GB_SCON',decode(substr(bal.balance_name,4,1),

438: --
439: CURSOR get_scon_bal(cp_l_asg_id number, cp_inp_val number, cp_element_type number) is
440: -- fetch the scon balances for NI F, NI G and/or NI S
441: select substr(bal.balance_name,4,1) cat_code,
442: substr(HR_GENERAL.DECODE_LOOKUP('GB_SCON',decode(substr(bal.balance_name,4,1),
443: 'F',nvl(max(EV_SCON.screen_entry_value),
444: pay_year_end_extract.get_nearest_scon(
445: max(EV_SCON.element_entry_id),'F',max(PACT.effective_date))),
446: 'G',nvl(max(EV_SCON.screen_entry_value),