127:
128: CURSOR c_cust_id_billto (p_cust_id IN NUMBER) IS
129: SELECT hzas.cust_account_id, hzas.org_id
130: FROM hz_cust_site_uses_all hzs,
131: hz_cust_acct_sites_all hzas
132: WHERE hzs.cust_acct_site_id = hzas.cust_acct_site_id
133: AND hzs.site_use_id = p_cust_id;
134:
135: CURSOR c_cust_id_shipto (p_cust_id IN NUMBER) IS
134:
135: CURSOR c_cust_id_shipto (p_cust_id IN NUMBER) IS
136: SELECT hzas.cust_account_id, hzs.bill_to_site_use_id, hzas.org_id
137: FROM hz_cust_site_uses_all hzs,
138: hz_cust_acct_sites_all hzas
139: WHERE hzs.cust_acct_site_id = hzas.cust_acct_site_id
140: AND hzs.site_use_id = p_cust_id;
141:
142: CURSOR c_valid_scantype_id (p_activity_id IN NUMBER, p_scan_type_id IN NUMBER) IS