DBA Data[Home] [Help]

APPS.PAY_GB_BACS_TAPE dependencies on PAY_PRE_PAYMENTS

Line 142: pay_pre_payments ppp,

138: ppp.personal_payment_method_id,
139: ppp.value,
140: pa.assignment_number
141: FROM pay_assignment_actions paa,
142: pay_pre_payments ppp,
143: per_assignments pa
144: WHERE paa.payroll_action_id = p_payroll_action_id
145: AND ppp.pre_payment_id = paa.pre_payment_id
146: AND paa.assignment_id = pa.assignment_id

Line 262: FROM pay_assignment_actions paa, pay_pre_payments ppp

258: BEGIN
259: hr_utility.set_location('bacsmgtp.get_org_context',1);
260: SELECT ppp.org_payment_method_id
261: INTO p_org_payment_method_id
262: FROM pay_assignment_actions paa, pay_pre_payments ppp
263: WHERE paa.payroll_action_id = p_payroll_action_id
264: AND ppp.pre_payment_id = paa.pre_payment_id
265: AND ROWNUM = 1
266: ORDER BY ppp.org_payment_method_id;