APPS.PAY_AU_EFT dependencies on PAY_ASSIGNMENT_ACTIONS

Line 94: , pay_assignment_actions paa

90: per_assignments_f a
91: , per_people_f p
92: , pay_external_accounts pea
93: , pay_pre_payments ppp
94: , pay_assignment_actions paa
95: , pay_personal_payment_methods_f pppm
96: where
97: ppp.pre_payment_id = paa.pre_payment_id
98: and paa.payroll_action_id = ppa.payroll_action_id

Line 148: , pay_assignment_actions paa

144: , pay_external_accounts oea
145: , pay_personal_payment_methods_f pppm
146: , pay_external_accounts pea
147: , pay_pre_payments ppp
148: , pay_assignment_actions paa
149: , pay_payroll_actions ppa
150: , per_assignments_f a /*bug 2900104*/
151: , per_people_f p
152: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID') /*bug 2900104*/

Line 184: pay_assignment_actions a,

180: , 'TRANSFER_HEAD_FLAG=P'
181: , decode(rownum,1,'Not_Printed','Printed')
182: from
183: pay_message_lines m,
184: pay_assignment_actions a,
185: pay_payroll_actions ppa,
186: (SELECT pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID') payroll_action_id FROM dual WHERE rownum=1) ppas
187: where
188: ppa.payroll_action_id = ppas.payroll_action_id