DBA Data[Home] [Help]

APPS.PAY_NL_PAYFILE_SEPA dependencies on PER_ALL_ASSIGNMENTS_F

Line 165: ,per_all_assignments_f paaf

161: SELECT 1
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

Line 224: FROM per_all_assignments_f paf

220: ,'BIC_EE=P'
221: ,nvl(min(pea.SEGMENT9),' ')
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