APPS.PN_INDEX_LEASE_TERMS_PKG dependencies on DUAL

Line 78: FROM DUAL

74:
75: BEGIN
76: SELECT '1'
77: INTO l_rowExists
78: FROM DUAL
79: WHERE EXISTS (
80: SELECT 1
81: FROM pn_index_lease_terms_all ilt
82: WHERE ilt.index_lease_id = x_index_lease_id

Line 96: SELECT PN_INDEX_LEASE_TERM_S.nextval into X_INDEX_LEASE_TERM_ID from dual;

92:
93: IF l_rowExists = '0' THEN
94:
95: IF (X_INDEX_LEASE_TERM_ID IS NULL) THEN
96: SELECT PN_INDEX_LEASE_TERM_S.nextval into X_INDEX_LEASE_TERM_ID from dual;
97: END IF;
98:
99: INSERT INTO PN_INDEX_LEASE_TERMS_ALL
100: (

Line 262: FROM DUAL

258:
259: BEGIN
260: SELECT '1'
261: INTO l_rowExists
262: FROM DUAL
263: WHERE EXISTS (
264: SELECT 1
265: FROM pn_index_lease_terms_all ilt
266: WHERE ilt.index_lease_id = x_index_lease_id