APPS.OKL_ARINTF_PVT dependencies on HZ_CUST_ACCT_SITES_ALL

Line 828: from hz_cust_acct_sites_all s,

824: and site_use_code = 'BILL_TO';
825:
826: CURSOR c_get_account_details (cp_customer_address_id NUMBER)IS
827: select a.cust_account_id, a.party_id
828: from hz_cust_acct_sites_all s,
829: hz_cust_accounts a
830: where s.cust_acct_site_id = cp_customer_address_id
831: AND s.cust_account_id = a.cust_account_id;
832:

Line 1586: from hz_cust_acct_sites_all s,

1582: -- gboomina modified for bug 6832065 - End
1583:
1584: CURSOR c_get_account_details (cp_customer_address_id NUMBER)IS
1585: select a.cust_account_id, a.party_id
1586: from hz_cust_acct_sites_all s,
1587: hz_cust_accounts a
1588: where s.cust_acct_site_id = cp_customer_address_id
1589: AND s.cust_account_id = a.cust_account_id;
1590:

Line 2333: FROM hz_cust_acct_sites_all a,

2329: AND inst.cle_id = p_kle_top_line;
2330:
2331: CURSOR Ship_to_csr2( p_customer_num NUMBER, p_install_location NUMBER, p_location NUMBER, p_org_id NUMBER ) IS
2332: SELECT a.CUST_ACCT_SITE_ID
2333: FROM hz_cust_acct_sites_all a,
2334: hz_cust_site_uses_all b,
2335: hz_party_sites c
2336: WHERE a.CUST_ACCT_SITE_ID = b.CUST_ACCT_SITE_ID AND
2337: b.site_use_code = 'SHIP_TO' AND