APPS.IGI_STP_CREATE_PCK_PKG dependencies on HZ_LOCATIONS

Line 183: HZ_LOCATIONS LOC,

179:
180: CURSOR get_customer_sites(p_customer_id in number ) is
181: select CSU.site_use_id, gl_id_rec
182: from HZ_PARTY_SITES PS,
183: HZ_LOCATIONS LOC,
184: HZ_CUST_ACCT_SITES_ALL CAS,
185: HZ_CUST_SITE_USES CSU
186: where CAS.party_site_id = PS.party_site_id
187: AND LOC.location_id = PS.location_id

Line 220: HZ_LOCATIONS LOC,

216:
217: cursor get_ar_site is
218: select CSU.site_use_id
219: from HZ_PARTY_SITES PS,
220: HZ_LOCATIONS LOC,
221: HZ_CUST_ACCT_SITES_ALL CAS,
222: HZ_CUST_SITE_USES CSU
223: where CAS.party_site_id = PS.party_site_id
224: AND LOC.location_id = PS.location_id