DBA Data[Home] [Help]

APPS.PAY_IE_P35_MAGTAPE dependencies on PAY_ACTION_INTERLOCKS

Line 41: pay_action_interlocks pai

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

Line 130: ,pay_action_interlocks pai

126: FROM
127: pay_assignment_actions paa
128: ,pay_action_information pact
129: ,pay_action_information pact1
130: ,pay_action_interlocks pai
131: WHERE
132: paa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
133: and pai.locking_action_id = paa.assignment_action_id
134: and paa.source_action_id is null