APPS.CN_PLAN_ELEMENT_PUB dependencies on CN_ACC_PERIOD_STATUSES_V

Line 4350: (Select period_id from cn_acc_period_statuses_v

4346: )
4347: IS
4348: SELECT 'Y'
4349: FROM dual where exists
4350: (Select period_id from cn_acc_period_statuses_v
4351: WHERE pe_start_date BETWEEN start_date and end_date
4352: AND period_status IN ('F', 'O') and org_id = p_org_id);
4353:
4354: --End: Added for fixing the bug#9664442