DBA Data[Home] [Help]

APPS.IGI_STP_CREATE_PCK_PKG dependencies on HZ_CUST_ACCT_SITES_ALL

Line 184: HZ_CUST_ACCT_SITES_ALL CAS,

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
188: and CAS.CUST_ACCOUNT_ID = p_customer_id

Line 221: HZ_CUST_ACCT_SITES_ALL CAS,

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
225: and CAS.CUST_ACCOUNT_ID = l_stp_id