APPS.PN_LEASE_CHANGES_PKG dependencies on DUAL

Line 117: FROM DUAL;

113: -- We need to INSERT a row IN pn_lease_transactions
114: --------------------------------------------------------
115: SELECT pn_lease_transactions_s.NEXTVAL
116: INTO l_leaseTransactionId
117: FROM DUAL;
118:
119: IF x_org_id IS NULL THEN
120: FOR rec IN org_cur LOOP
121: l_org_id := rec.org_id;

Line 162: FROM DUAL;

158: --------------------------------------------------------
159: IF (x_lease_change_id IS NULL) THEN
160: SELECT pn_lease_changes_s.NEXTVAL
161: INTO x_lease_change_id
162: FROM DUAL;
163: END IF;
164:
165: INSERT INTO pn_lease_changes_all
166: (

Line 602: FROM DUAL

598: IF (X_CHANGE_TYPE_LOOKUP_CODE = 'ABSTRACT') THEN
599: BEGIN
600: SELECT 1
601: INTO l_dummy
602: FROM DUAL
603: WHERE NOT EXISTS (SELECT 1
604: FROM pn_lease_changes_all plc
605: WHERE plc.change_type_lookup_code = x_change_type_lookup_code
606: AND plc.lease_id = X_LEASE_ID

Line 620: FROM DUAL

616: WHERE lease_id = X_LEASE_ID;
617:
618: SELECT 1
619: INTO l_dummy
620: FROM DUAL
621: WHERE NOT EXISTS (SELECT 1
622: FROM pn_lease_changes_all plc
623: WHERE plc.change_type_lookup_code = X_CHANGE_TYPE_LOOKUP_CODE
624: AND plc.lease_change_number = X_LEASE_CHANGE_NUMBER