APPS.PNT_PAYMENT_SCHEDULES_PKG dependencies on DUAL

Line 72: FROM DUAL

68: BEGIN
69:
70: SELECT 1
71: INTO dummy
72: FROM DUAL
73: WHERE NOT EXISTS (SELECT 1
74: FROM pn_payment_schedules_all
75: WHERE lease_id = x_lease_id
76: AND TO_CHAR(schedule_date,'YYYY-MON-DD') = TO_CHAR(x_schedule_date,'YYYY-MON-DD')

Line 316: FROM DUAL

312: l_check_cond VARCHAR2(1) := NULL;
313:
314: CURSOR on_hold_cur IS
315: SELECT 'A'
316: FROM DUAL
317: WHERE EXISTS (SELECT NULL
318: FROM pn_payment_schedules_all
319: WHERE lease_id = x_lease_id
320: AND schedule_date < x_schedule_date

Line 387: FROM dual

383: AND payment_item_type_lookup_code = 'CASH';
384:
385: CURSOR chk_item_exists IS
386: SELECT 'Y'
387: FROM dual
388: WHERE EXISTS (SELECT null
389: FROM pn_payment_items_all
390: WHERE payment_schedule_id = p_payment_schedule_id
391: AND payment_item_type_lookup_code = 'CASH'

Line 516: FROM DUAL;

512: IF x_payment_schedule_id IS NULL THEN
513:
514: SELECT pn_payment_schedules_s.NEXTVAL
515: INTO x_payment_schedule_id
516: FROM DUAL;
517:
518: END IF;
519:
520: IF x_org_id IS NULL THEN