APPS.PN_INDEX_LEASE_CONSTRAINTS_PKG dependencies on DUAL

Line 93: FROM DUAL;

89:
90: IF (x_index_constraint_id IS NULL) THEN
91: SELECT pn_index_lease_constraints_s.NEXTVAL
92: INTO x_index_constraint_id
93: FROM DUAL;
94: END IF;
95:
96: IF x_org_id IS NULL THEN
97: FOR rec IN org_cur LOOP

Line 451: FROM DUAL

447: l_dummy NUMBER;
448: BEGIN
449: SELECT 1
450: INTO l_dummy
451: FROM DUAL
452: WHERE NOT EXISTS ( SELECT 1
453: FROM pn_index_lease_constraints_all
454: WHERE (scope = x_scope)
455: AND (index_lease_id = x_index_lease_id)