APPS.ASO_MAP_QUOTE_ORDER_INT dependencies on HZ_CUST_SITE_USES

Line 116: select cust_acct_site_id from hz_cust_site_uses

112:
113: -- Change END
114:
115: CURSOR get_cust_acct_site_id(l_site_use_id number) IS
116: select cust_acct_site_id from hz_cust_site_uses
117: where site_use_id = l_site_use_id;
118:
119: CURSOR C_get_quote_number(l_qte_hdr_id NUMBER) IS
120: SELECT quote_number, quote_version

Line 2523: hz_cust_site_uses a, hz_cust_acct_sites b

2519: and b.party_id = a.party_id;
2520: CURSOR site_use_cur IS
2521: select a.site_use_id, b.status,a.status
2522: from
2523: hz_cust_site_uses a, hz_cust_acct_sites b
2524: where
2525: b.cust_account_id = p_cust_account_id
2526: and b.party_site_id = p_party_site_id
2527: and a.cust_acct_site_id = b.cust_acct_site_id