APPS.PAY_AU_EFT dependencies on PAY_PAYROLL_ACTIONS

Line 76: , pay_payroll_actions ppa

72: , NVL(ppf.payroll_name,'Salary/Wages')
73: from
74: pay_org_payment_methods_f popm
75: , pay_external_accounts oea
76: , pay_payroll_actions ppa
77: , pay_payrolls_f ppf
78: where
79: ppa.payroll_action_id =
80: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

Line 149: , pay_payroll_actions ppa

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*/
153: and paa.payroll_action_id = ppa.payroll_action_id

Line 171: /* Bug No: 3603495 - Performance fix in the following cursor. Introduced pay_payroll_actions and its join */

167: ;
168: /*
169: ** Cursor to retrieve Westpac Direct Entry system control info
170: */
171: /* Bug No: 3603495 - Performance fix in the following cursor. Introduced pay_payroll_actions and its join */
172: cursor c_aba_msg is
173: select
174: 'SOURCE_ID=P'
175: , source_id

Line 185: pay_payroll_actions ppa,

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
189: and a.payroll_action_id = ppa.payroll_action_id