APPS.PN_INDEX_EXCLUDE_TERM_PKG dependencies on DUAL

Line 45: FROM DUAL

41:
42: BEGIN
43: SELECT '1'
44: INTO l_rowExists
45: FROM DUAL
46: WHERE EXISTS ( SELECT 1
47: FROM pn_index_exclude_term_all exclude
48: WHERE exclude.index_lease_id = x_index_lease_id
49: AND exclude.payment_term_id = x_payment_term_id

Line 71: FROM dual;

67:
68: IF (X_INDEX_EXCLUDE_TERM_ID IS NULL) THEN
69: SELECT PN_INDEX_EXCLUDE_TERM_s.nextval
70: INTO X_INDEX_EXCLUDE_TERM_ID
71: FROM dual;
72: END IF;
73:
74: INSERT INTO PN_INDEX_EXCLUDE_TERM_ALL
75: (

Line 241: FROM DUAL

237:
238: BEGIN
239: SELECT '1'
240: INTO l_rowExists
241: FROM DUAL
242: WHERE EXISTS ( SELECT 1
243: FROM pn_index_exclude_term_all exclude
244: WHERE exclude.index_lease_id = x_index_lease_id
245: AND exclude.payment_term_id = x_payment_term_id);