DBA Data[Home] [Help]

APPS.PAY_NL_PAYFILE dependencies on PAY_MAGTAPE_GENERIC

Line 63: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

59: ,'ORG_PAY_METHOD_ID=C'
60: ,ppa.org_payment_method_id
61: FROM pay_payroll_actions ppa
62: WHERE ppa.payroll_action_id =
63: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
64: AND EXISTS (
65: SELECT 1
66: FROM pay_assignment_actions pas
67: ,pay_pre_payments ppp

Line 113: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

109: ,pay_payroll_actions ppa
110: ,pay_personal_payment_methods_f ppmf
111: ,pay_external_accounts pea
112: WHERE paa.payroll_action_id =
113: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
114: AND paa.pre_payment_id = ppp.pre_payment_id
115: AND paa.payroll_action_id = ppa.payroll_action_id
116: AND PPP.personal_payment_method_id = ppmf.personal_payment_method_id
117: AND paa.assignment_id = paf.assignment_id