DBA Data[Home] [Help]

APPS.PAY_IE_PAYFILE_SEPA dependencies on PAY_ALL_PAYROLLS_F

Line 437: PAY_ALL_PAYROLLS_F papf,

433: from hr_all_organization_units hou,
434: hr_organization_information hoi,
435: pay_org_payment_methods_f popmf,
436: PAY_ORG_PAY_METHOD_USAGES_F popmu,
437: PAY_ALL_PAYROLLS_F papf,
438: PAY_EXTERNAL_ACCOUNTS pea,
439: PAY_PAYROLL_ACTIONS ppa,
440: hr_soft_coding_keyflex hsck
441: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

Line 463: ,pay_all_payrolls_f ppf

459: (SELECT 1
460: FROM pay_assignment_actions pas
461: ,pay_pre_payments ppp
462: ,per_all_assignments_f paaf
463: ,pay_all_payrolls_f ppf
464: ,hr_soft_coding_keyflex hsck1
465: WHERE pas.payroll_action_id = ppa.payroll_action_id
466: AND ppp.pre_payment_id = pas.pre_payment_id
467: AND ppp.value > 0

Line 490: ,pay_all_payrolls_f ppf

486: FROM (SELECT SUM(ppp.value*100) employer_sum,
487: 1 record_count
488: FROM per_all_assignments_f paf
489: ,per_all_people_f pef
490: ,pay_all_payrolls_f ppf
491: ,pay_pre_payments ppp
492: ,pay_assignment_actions paa
493: ,pay_payroll_actions ppa
494: ,pay_personal_payment_methods_f ppmf