APPS.PN_LEASES_PKG dependencies on DUAL

Line 637: FROM DUAL

633: pnp_debug_pkg.debug ('PN_LEASES_PKG.check_UNIQUE_lease_number (+)');
634:
635: SELECT 1
636: INTO l_dummy
637: FROM DUAL
638: WHERE NOT EXISTS (SELECT 1
639: FROM pn_leases pnl
640: WHERE pnl.lease_num = x_lease_number
641: AND ((x_lease_id IS NULL) OR (pnl.lease_id <> x_lease_id))

Line 677: FROM DUAL

673: pnp_debug_pkg.debug ('PN_LEASES_PKG.check_UNIQUE_lease_number (+)');
674:
675: SELECT 1
676: INTO l_dummy
677: FROM DUAL
678: WHERE NOT EXISTS (SELECT 1
679: FROM pn_leases_all pnl
680: WHERE pnl.lease_num = x_lease_number
681: AND ((x_lease_id IS NULL) OR (pnl.lease_id <> x_lease_id))