APPS.PAY_NL_PAYFILE_SEPA dependencies on PAY_PAYROLL_ACTIONS

Line 91: FROM pay_payroll_actions ppa

87: ,'TRANSFER_ERROR_FLAG=P'
88: ,'N'
89: ,'INSTR_IDENT=P'
90: ,NVL(pay_nl_general.get_parameter(ppa.legislative_parameters,'INSTR_IDENT'),' ')
91: FROM pay_payroll_actions ppa
92: WHERE ppa.payroll_action_id =
93: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
94: AND EXISTS (
95: SELECT 1

Line 140: PAY_PAYROLL_ACTIONS ppa

136: pay_org_payment_methods_f popmf,
137: PAY_ORG_PAY_METHOD_USAGES_F popmu,
138: PAY_ALL_PAYROLLS_F papf,
139: PAY_EXTERNAL_ACCOUNTS pea,
140: PAY_PAYROLL_ACTIONS ppa
141: where
142: ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID') and
143: hou.business_group_id = ppa.business_group_id and
144: hoi.org_information_context = 'NL_ORG_INFORMATION' and

Line 229: ,pay_payroll_actions ppa

225: ,per_all_people_f pef
226: ,pay_all_payrolls_f ppf
227: ,pay_pre_payments ppp
228: ,pay_assignment_actions paa
229: ,pay_payroll_actions ppa
230: ,pay_personal_payment_methods_f ppmf
231: ,pay_external_accounts pea
232: WHERE paa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
233: AND paa.pre_payment_id = ppp.pre_payment_id