DBA Data[Home] [Help]

APPS.PAY_CA_YEER_PKG dependencies on PAY_ACTION_INFORMATION

Line 3427: from pay_action_information pai,

3423: cursor cur_rl_nonbox_footnote(cp_asgact_id number) is
3424: select pai.action_information5,
3425: flv.meaning,
3426: 'CAEOY_RL1_NONBOX_FOOTNOTE'
3427: from pay_action_information pai,
3428: fnd_lookup_types flt,
3429: fnd_lookup_values flv
3430: where pai.action_context_id = cp_asgact_id
3431: and pai.action_context_type = 'AAP'

Line 3453: FROM pay_action_information pai_emp

3449: /* Bug 15908332 */
3450: cursor c_further_codes(cp_asgact_id number) is
3451: select pai_emp.ACTION_INFORMATION4 code, pai_emp.ACTION_INFORMATION5 value,
3452: initcap(rtrim(ltrim(replace(replace(replace(pai_emp.ACTION_INFORMATION4,'RL2_'),'AMOUNT_'),'_',' ')))) short_name
3453: FROM pay_action_information pai_emp
3454: ,pay_assignment_actions paa_arch
3455: ,pay_payroll_actions ppa_arch
3456: where pai_emp.action_context_id=cp_asgact_id
3457: AND pai_emp.action_context_id = paa_arch.assignment_action_id

Line 3986: from pay_action_information pai,

3982: cursor cur_t4a_nonbox_footnote(cp_asgact_id number) is
3983: select pai.action_information5,
3984: flv.meaning,
3985: 'CAEOY_T4A_NONBOX_FOOTNOTE'
3986: from pay_action_information pai,
3987: fnd_lookup_types flt,
3988: fnd_lookup_values flv
3989: where pai.action_context_id = cp_asgact_id
3990: and pai.action_context_type = 'AAP'