DBA Data[Home] [Help]

APPS.PAY_IE_P35_MAGTAPE dependencies on PAY_ACTION_INTERLOCKS

Line 40: pay_action_interlocks pai

36: AND ppa.payroll_action_id =
37: (select max(arc_paa.payroll_action_id) from
38: pay_assignment_actions mag_paa,
39: pay_assignment_actions arc_paa,
40: pay_action_interlocks pai
41: where mag_paa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
42: and pai.locking_action_id = mag_paa.assignment_action_id
43: and arc_paa.assignment_action_id= pai.locked_action_id);
44:

Line 108: ,pay_action_interlocks pai

104: FROM
105: pay_assignment_actions paa
106: ,pay_action_information pact
107: ,pay_action_information pact1
108: ,pay_action_interlocks pai
109: WHERE
110: paa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
111: and pai.locking_action_id = paa.assignment_action_id
112: and paa.source_action_id is null