DBA Data[Home] [Help]

APPS.PAY_NL_PAYFILE_SEPA dependencies on PAY_MAGTAPE_GENERIC

Line 567: ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID') and

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
568: hou.business_group_id = ppa.business_group_id and
569: hoi.org_information_context = 'NL_ORG_INFORMATION' and
570: hou.organization_id = hoi.organization_id and
571: popmu.org_payment_method_id = ppa.org_payment_method_id and

Line 622: WHERE paa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

618: ,pay_assignment_actions paa
619: ,pay_payroll_actions ppa
620: ,pay_personal_payment_methods_f ppmf
621: ,pay_external_accounts pea
622: WHERE paa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
623: AND paa.pre_payment_id = ppp.pre_payment_id
624: AND paa.payroll_action_id = ppa.payroll_action_id
625: AND PPP.personal_payment_method_id = ppmf.personal_payment_method_id
626: AND paa.assignment_id = paf.assignment_id