102: AND status= 'A';
103:
104: CURSOR c_cust_id_billto (p_cust_id IN NUMBER) IS
105: SELECT hzas.cust_account_id
106: FROM hz_cust_site_uses_all hzs,
107: hz_cust_acct_sites_all hzas
108: WHERE hzs.cust_acct_site_id = hzas.cust_acct_site_id
109: AND hzs.site_use_id = p_cust_id;
110:
109: AND hzs.site_use_id = p_cust_id;
110:
111: CURSOR c_cust_id_shipto (p_cust_id IN NUMBER) IS
112: SELECT hzas.cust_account_id, hzs.bill_to_site_use_id
113: FROM hz_cust_site_uses_all hzs,
114: hz_cust_acct_sites_all hzas
115: WHERE hzs.cust_acct_site_id = hzas.cust_acct_site_id
116: AND hzs.site_use_id = p_cust_id;
117: