APPS.OKC_PRICE_PUB dependencies on OKX_CUST_SITES_V

Line 2434: FROM okx_cust_sites_v a,

2430: l_ship_id number;
2431: i pls_integer :=0;
2432: CURSOR get_ship_to_site_id_cur (l_ship_to_org_id NUMBER) IS
2433: SELECT a.party_site_id
2434: FROM okx_cust_sites_v a,
2435: okx_cust_site_uses_v b
2436: WHERE a.cust_acct_site_id = b.cust_acct_site_id
2437: AND b.id1 = l_ship_to_org_id
2438: AND b.site_use_code = 'SHIP_TO';

Line 2468: FROM okx_cust_sites_v a,

2464: l_bill_id number;
2465: i pls_integer :=0;
2466: CURSOR get_bill_to_site_id_cur (l_bill_to_org_id NUMBER) IS
2467: SELECT a.party_site_id
2468: FROM okx_cust_sites_v a,
2469: okx_cust_site_uses_v b
2470: WHERE a.cust_acct_site_id = b.cust_acct_site_id
2471: AND b.id1 = l_bill_to_org_id
2472: AND b.site_use_code = 'BILL_TO';