APPS.PAY_IE_P35_MAGTAPE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 39: pay_assignment_actions mag_paa,

35: AND pact.action_information_category = 'ADDRESS DETAILS'
36: AND pact.action_context_type = 'PA'
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

Line 40: pay_assignment_actions arc_paa,

36: AND pact.action_context_type = 'PA'
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)

Line 46: AND EXISTS ( SELECT 1 FROM PAY_ASSIGNMENT_ACTIONS PAA

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
46: AND EXISTS ( SELECT 1 FROM PAY_ASSIGNMENT_ACTIONS PAA
47: WHERE PAA.payroll_action_id = ppa.payroll_action_id
48: AND PAA.TAX_UNIT_ID = pay_ie_p35.get_parameter(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'),'EMP_NO'));
49: --16210193
50:

Line 127: pay_assignment_actions paa

123: ,pact1.action_information22 --14656910V9
124: --14656910
125:
126: FROM
127: pay_assignment_actions paa
128: ,pay_action_information pact
129: ,pay_action_information pact1
130: ,pay_action_interlocks pai
131: WHERE