DBA Data[Home] [Help]

APPS.PAY_AU_EFT dependencies on PAY_ASSIGNMENT_ACTIONS

Line 93: , pay_assignment_actions paa

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

Line 147: , pay_assignment_actions paa

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

Line 183: pay_assignment_actions a,

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