DBA Data[Home] [Help]

APPS.PAY_NL_PAYFILE_SEPA dependencies on PAY_ALL_PAYROLLS_F

Line 138: PAY_ALL_PAYROLLS_F papf,

134: hr_all_organization_units hou,
135: hr_organization_information hoi,
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

Line 166: ,pay_all_payrolls_f ppf

162: FROM
163: pay_assignment_actions pas
164: ,pay_pre_payments ppp
165: ,per_all_assignments_f paaf
166: ,pay_all_payrolls_f ppf
167: WHERE pas.payroll_action_id = ppa.payroll_action_id
168: AND ppp.pre_payment_id = pas.pre_payment_id
169: AND ppp.value > 0
170: AND paaf.assignment_id = pas.assignment_id

Line 226: ,pay_all_payrolls_f ppf

222: ,'NATIONAL_IDENTIFIER=P'
223: ,min(pef.NATIONAL_IDENTIFIER)
224: FROM per_all_assignments_f paf
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