APPS.PN_INDEX_RENT_PERIODS_PKG dependencies on DUAL

Line 350: FROM DUAL

346: var number;
347:
348: CURSOR exists_approved_schedule( p_payment_term_id IN NUMBER) IS
349: SELECT 'Y'
350: FROM DUAL
351: WHERE EXISTS( SELECT payment_item_id
352: FROM pn_payment_items_all items,
353: pn_payment_schedules_all sched
354: WHERE sched.payment_schedule_id = items.payment_schedule_id

Line 2556: FROM DUAL

2552:
2553: CURSOR bkhd_exists_cur
2554: IS
2555: select 'x'
2556: FROM DUAL
2557: where exists (select BKHD_DEFAULT_ID
2558: from pn_var_bkpts_head_all
2559: where period_id IN (select PERIOD_ID
2560: FROM pn_var_periods_all