DBA Data[Home] [Help]

APPS.PAY_KW_EFT dependencies on PAY_MAGTAPE_GENERIC

Line 134: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

130: ,'SUM1=P'
131: ,pay_kw_general.get_sum * 1000
132: FROM pay_payroll_actions ppa
133: WHERE ppa.payroll_action_id =
134: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
135: AND EXISTS (
136: SELECT 1
137: FROM pay_assignment_actions pas
138: ,pay_pre_payments ppp

Line 179: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

175: ,pay_pre_payments ppp
176: ,pay_assignment_actions paa
177: ,pay_payroll_actions ppa
178: WHERE paa.payroll_action_id =
179: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
180: AND paa.pre_payment_id = ppp.pre_payment_id
181: AND paa.payroll_action_id = ppa.payroll_action_id
182: AND paa.assignment_id = paf.assignment_id
183: AND paf.person_id = pef.person_id