DBA Data[Home] [Help]

APPS.PAY_NL_ANNUAL_SI_FILE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 18: (select * from pay_assignment_actions paa

14: FROM pay_payroll_actions ppa
15: WHERE ppa.payroll_action_id
16: =pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
17: AND EXISTS
18: (select * from pay_assignment_actions paa
19: where paa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'));
20:
21:
22: Cursor Csr_NL_Annual_SI_Body IS

Line 35: pay_assignment_actions pay_act,

31: 'ASI_SUP_DAYS=P' ,ee_asi.action_information7 ,
32: 'ASI_AMT_ALLOWANCE=P' ,ee_asi.action_information8 ,
33: 'ASI_SPL_IND=P' ,ee_asi.action_information9
34: FROM
35: pay_assignment_actions pay_act,
36: pay_action_interlocks arc_lck,
37: pay_action_information ee_asi,
38: per_all_people_f pap
39: WHERE pay_act.payroll_action_id