DBA Data[Home] [Help]

APPS.PAY_NL_PAYFILE_SEPA dependencies on PAY_ALL_PAYROLLS_F

Line 563: PAY_ALL_PAYROLLS_F papf,

559: hr_all_organization_units hou,
560: hr_organization_information hoi,
561: pay_org_payment_methods_f popmf,
562: PAY_ORG_PAY_METHOD_USAGES_F popmu,
563: PAY_ALL_PAYROLLS_F papf,
564: PAY_EXTERNAL_ACCOUNTS pea,
565: PAY_PAYROLL_ACTIONS ppa
566: where
567: ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID') and

Line 591: ,pay_all_payrolls_f ppf

587: FROM
588: pay_assignment_actions pas
589: ,pay_pre_payments ppp
590: ,per_all_assignments_f paaf
591: ,pay_all_payrolls_f ppf
592: WHERE pas.payroll_action_id = ppa.payroll_action_id
593: AND ppp.pre_payment_id = pas.pre_payment_id
594: AND ppp.value > 0
595: AND paaf.assignment_id = pas.assignment_id

Line 616: ,pay_all_payrolls_f ppf

612: (SELECT
613: SUM(ppp.value*100) employer_sum, 1 record_count
614: FROM per_all_assignments_f paf
615: ,per_all_people_f pef
616: ,pay_all_payrolls_f ppf
617: ,pay_pre_payments ppp
618: ,pay_assignment_actions paa
619: ,pay_payroll_actions ppa
620: ,pay_personal_payment_methods_f ppmf