APPS.PAY_VOID_REVERSAL_PKG dependencies on PAY_PRE_PAYMENTS

Line 154: ,pay_pre_payments ppp

150: ,pay_assignment_actions paa
151: ,pay_all_payrolls_f papf
152: ,pay_consolidation_sets pcs
153: ,pay_org_payment_methods_f popmf
154: ,pay_pre_payments ppp
155: WHERE paa.assignment_action_id = p_check_assignment_action
156: AND ppp.pre_payment_id = paa.pre_payment_id
157: AND ppa.payroll_action_id = paa.payroll_action_id
158: AND papf.payroll_id = ppa.payroll_id

Line 168: FROM pay_pre_payments ppp

164: OR (
165: popmf.org_payment_method_id IN
166: (
167: SELECT ppp.org_payment_method_id
168: FROM pay_pre_payments ppp
169: ,pay_assignment_actions paa
170: WHERE paa.payroll_action_id = ppa.payroll_action_id
171: AND paa.pre_payment_id = ppp.pre_payment_id
172: )

Line 445: l_pre_payment_id pay_pre_payments.pre_payment_id%TYPE;

441: l_payroll_id pay_payroll_actions.payroll_id%TYPE;
442: l_assignment_id pay_assignment_actions.assignment_id%TYPE ;
443: l_prepayment_asg_action pay_assignment_actions.assignment_action_id%TYPE ;
444: l_serial_number pay_assignment_actions.serial_number%TYPE;
445: l_pre_payment_id pay_pre_payments.pre_payment_id%TYPE;
446: l_request_id number;
447: --
448: l_wait_outcome BOOLEAN;
449: l_phase VARCHAR2(80);

Line 475: pay_pre_payments ppp, pay_action_interlocks pal

471: into l_prepayment_asg_action, l_payroll_id, l_assignment_id,
472: l_pre_payment_id, l_serial_number
473: from pay_payroll_actions ppa, pay_assignment_actions paa,
474: pay_assignment_actions paa2, pay_all_payrolls_f papf,
475: pay_pre_payments ppp, pay_action_interlocks pal
476: where pal.locking_action_id = p_check_assignment_action
477: and paa2.assignment_action_id = p_check_assignment_action
478: and paa.assignment_action_id = pal.locked_action_id
479: and ppa.payroll_action_id = paa.payroll_action_id