APPS.PAY_GB_BACS_TAPE dependencies on PAY_PRE_PAYMENTS

Line 147: pay_pre_payments ppp,

143: ppp.personal_payment_method_id,
144: ppp.value,
145: pa.assignment_number
146: FROM pay_assignment_actions paa,
147: pay_pre_payments ppp,
148: per_assignments pa
149: WHERE paa.payroll_action_id = p_payroll_action_id
150: AND ppp.pre_payment_id = paa.pre_payment_id
151: AND paa.assignment_id = pa.assignment_id

Line 267: FROM pay_assignment_actions paa, pay_pre_payments ppp

263: BEGIN
264: hr_utility.set_location('bacsmgtp.get_org_context',1);
265: SELECT ppp.org_payment_method_id
266: INTO p_org_payment_method_id
267: FROM pay_assignment_actions paa, pay_pre_payments ppp
268: WHERE paa.payroll_action_id = p_payroll_action_id
269: AND ppp.pre_payment_id = paa.pre_payment_id
270: AND ROWNUM = 1
271: ORDER BY ppp.org_payment_method_id;