1320: l_ship_to_party_site_id NUMBER;
1321:
1322: CURSOR get_ship_to_site_id_cur (l_ship_to_org_id NUMBER) IS
1323: SELECT a.party_site_id
1324: FROM hz_cust_acct_sites a,
1325: hz_cust_site_uses b
1326: WHERE a.cust_acct_site_id = b.cust_acct_site_id
1327: AND b.site_use_id = l_ship_to_org_id
1328: AND b.site_use_code = 'SHIP_TO';
1345: l_bill_to_party_site_id NUMBER;
1346:
1347: CURSOR get_bill_to_site_id_cur (l_bill_to_org_id NUMBER) IS
1348: SELECT a.party_site_id
1349: FROM hz_cust_acct_sites a,
1350: hz_cust_site_uses b
1351: WHERE a.cust_acct_site_id = b.cust_acct_site_id
1352: AND b.site_use_id = l_bill_to_org_id
1353: AND b.site_use_code = 'BILL_TO';