APPS.PN_INDEX_LEASES_PKG dependencies on DUAL

Line 148: FROM DUAL;

144: IF (x_index_lease_id IS NULL)
145: THEN
146: SELECT pn_index_leases_s.NEXTVAL
147: INTO x_index_lease_id
148: FROM DUAL;
149: END IF;
150:
151:
152: /* If no index lease number is provided, use system generated index lease id */

Line 940: FROM DUAL

936: l_dummy NUMBER;
937: BEGIN
938: SELECT 1
939: INTO l_dummy
940: FROM DUAL
941: WHERE NOT EXISTS ( SELECT 1
942: FROM pn_index_leases_all
943: WHERE (index_lease_number = x_index_lease_number)
944: AND ( (x_index_lease_id IS NULL)