APPS.PAY_VOID_PAYMENTS dependencies on PAY_CE_RECONCILED_PAYMENTS

Line 60: -- from pay_ce_reconciled_payments prp

56: act.object_version_number,
57: act.action_status,
58: act.tax_unit_id,
59: -- nvl((select distinct 'Y'
60: -- from pay_ce_reconciled_payments prp
61: -- where prp.assignment_action_id = act.assignment_action_id)
62: -- ,'N') recon_exists,
63: nvl(pos.final_process_date, hr_general.end_of_time) final_process_date
64: FROM pay_assignment_actions act,

Line 87: FROM pay_ce_reconciled_payments prp

83: AND asg.effective_end_date ;
84: --
85: CURSOR csr_payment_reconciled (v_asg_act_id number) IS
86: SELECT 'Y'
87: FROM pay_ce_reconciled_payments prp
88: WHERE prp.assignment_action_id = v_asg_act_id;
89: --
90: l_dummy varchar2(1);
91: --