APPS.ASO_MAP_QUOTE_ORDER_INT dependencies on HZ_CUST_SITE_USES

Line 118: select cust_acct_site_id from hz_cust_site_uses

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

Line 2577: hz_cust_site_uses a, hz_cust_acct_sites b

2573:
2574: CURSOR site_use_cur IS
2575: select a.site_use_id, b.status,a.status
2576: from
2577: hz_cust_site_uses a, hz_cust_acct_sites b
2578: where
2579: b.cust_account_id = p_cust_account_id
2580: and b.party_site_id = p_party_site_id
2581: and a.cust_acct_site_id = b.cust_acct_site_id