APPS.PN_INDEX_LEASES_PKG dependencies on PN_LEASES_ALL

Line 135: SELECT org_id FROM pn_leases_all WHERE lease_id = x_lease_id;

131: l_return_status VARCHAR2 (30) := NULL;
132: l_rowid VARCHAR2 (18) := NULL;
133:
134: CURSOR org_cur IS
135: SELECT org_id FROM pn_leases_all WHERE lease_id = x_lease_id;
136: l_org_ID NUMBER;
137:
138: BEGIN
139: