APPS.IGI_STP_CREATE_PCK_PKG dependencies on HZ_PARTY_SITES

Line 182: from HZ_PARTY_SITES PS,

178: where vendor_id = p_vendor_id;
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

Line 219: from HZ_PARTY_SITES PS,

215: -- l_currency_code varchar2(15);
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