DBA Data[Home] [Help]

APPS.PAY_IE_P35_MAGTAPE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 38: pay_assignment_actions mag_paa,

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

Line 39: pay_assignment_actions arc_paa,

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

Line 105: pay_assignment_actions paa

101: ('MEDICAL_INSURANCE=P') -- 5867343
102: ,pact1.action_information17 -- 5867343
103:
104: FROM
105: pay_assignment_actions paa
106: ,pay_action_information pact
107: ,pay_action_information pact1
108: ,pay_action_interlocks pai
109: WHERE