DBA Data[Home] [Help]

APPS.IGI_STP_CREATE_PCK_PKG dependencies on HZ_CUST_SITE_USES

Line 185: HZ_CUST_SITE_USES CSU

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
189: and CSU.cust_acct_site_id = CAS.cust_acct_site_id

Line 222: HZ_CUST_SITE_USES CSU

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
226: and CSU.cust_acct_site_id = CAS.cust_acct_site_id