APPS.PAY_VOID_PAYMENTS dependencies on PAY_CE_RECONCILED_PAYMENTS

Line 59: -- from pay_ce_reconciled_payments prp

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

Line 86: FROM pay_ce_reconciled_payments prp

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