APPS.IGI_STP_TABLE_HANDLER_PKG dependencies on HZ_LOC_ASSIGNMENTS

Line 61: CURSOR C4 IS SELECT location_id FROM HZ_LOC_ASSIGNMENTS

57: CURSOR C2 IS SELECT rowid FROM HZ_CUST_ACCT_SITES
58: WHERE cust_acct_site_id = X_address_id;
59: CURSOR C3 IS SELECT address_id FROM IGI_RA_ADDRESSES
60: WHERE address_id = X_address_id;
61: CURSOR C4 IS SELECT location_id FROM HZ_LOC_ASSIGNMENTS
62: WHERE location_id = X_location_id;
63:
64: c_location_id number(15);
65: c1_party_site_id number(15);