APPS.PAY_AU_EFT dependencies on PAY_PAYROLL_ACTIONS

Line 75: , pay_payroll_actions ppa

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

Line 148: , pay_payroll_actions ppa

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

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

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

Line 184: pay_payroll_actions ppa,

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