DBA Data[Home] [Help]

APPS.PAY_IE_PAYFILE_SEPA dependencies on PAY_MAGTAPE_GENERIC

Line 441: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

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')
442: and hou.business_group_id = ppa.business_group_id
443: and hoi.org_information_context(+) = 'IE_PAYPATH_INFORMATION'
444: and hou.organization_id = hoi.organization_id
445: and popmu.org_payment_method_id = ppa.org_payment_method_id

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

492: ,pay_assignment_actions paa
493: ,pay_payroll_actions ppa
494: ,pay_personal_payment_methods_f ppmf
495: ,pay_external_accounts pea
496: WHERE paa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
497: AND paa.pre_payment_id = ppp.pre_payment_id
498: AND paa.payroll_action_id = ppa.payroll_action_id
499: AND PPP.personal_payment_method_id = ppmf.personal_payment_method_id
500: AND paa.assignment_id = paf.assignment_id