APPS.PAY_JP_ZENGIN_TAPE dependencies on PAY_PRE_PAYMENTS

Line 101: pay_pre_payments ppp,

97: ppp.personal_payment_method_id,
98: ppp.value,
99: pa.assignment_number
100: FROM pay_assignment_actions paa,
101: pay_pre_payments ppp,
102: per_assignments pa
103: WHERE paa.payroll_action_id = p_payroll_action_id
104: AND ppp.pre_payment_id = paa.pre_payment_id
105: AND paa.assignment_id = pa.assignment_id

Line 225: FROM pay_assignment_actions paa, pay_pre_payments ppp

221: BEGIN
222: hr_utility.set_location('bacsmgtp.get_org_context',1);
223: SELECT ppp.org_payment_method_id
224: INTO p_org_payment_method_id
225: FROM pay_assignment_actions paa, pay_pre_payments ppp
226: WHERE paa.payroll_action_id = p_payroll_action_id
227: AND ppp.pre_payment_id = paa.pre_payment_id
228: AND ROWNUM = 1
229: ORDER BY ppp.org_payment_method_id;