DBA Data[Home] [Help]

APPS.PN_INDEX_EXCLUDE_TERM_PKG dependencies on PN_INDEX_LEASES_ALL

Line 34: SELECT org_id FROM pn_index_leases_all WHERE index_lease_id = x_index_lease_id;

30: l_rowId VARCHAR2(18) := NULL;
31: l_rowExists VARCHAR2(10) := NULL;
32:
33: CURSOR org_cur IS
34: SELECT org_id FROM pn_index_leases_all WHERE index_lease_id = x_index_lease_id;
35: l_org_ID NUMBER;
36: BEGIN
37:
38: PNP_DEBUG_PKG.debug (' PN_INDEX_EXCLUDE_TERM_PKG.insert_row (+)');