APPS.PN_INDEX_RENT_PERIODS_PKG dependencies on DUAL

Line 355: FROM DUAL

351: var number;
352:
353: CURSOR exists_approved_schedule( p_payment_term_id IN NUMBER) IS
354: SELECT 'Y'
355: FROM DUAL
356: WHERE EXISTS( SELECT payment_item_id
357: FROM pn_payment_items_all items,
358: pn_payment_schedules_all sched
359: WHERE sched.payment_schedule_id = items.payment_schedule_id

Line 2700: FROM DUAL

2696:
2697: CURSOR bkhd_exists_cur
2698: IS
2699: select 'x'
2700: FROM DUAL
2701: where exists (select BKHD_DEFAULT_ID
2702: from pn_var_bkpts_head_all
2703: where period_id IN (select PERIOD_ID
2704: FROM pn_var_periods_all