APPS.OKS_UTIL_PUB dependencies on HZ_CUST_ACCOUNTS

Line 765: FROM hz_cust_accounts ca,

761:
762: -- Covered Customer Accounts
763: CURSOR customercur IS
764: SELECT NVL(ca.account_name, p.party_name) name
765: FROM hz_cust_accounts ca,
766: hz_parties p
767: WHERE ca.party_id = p.party_id
768: AND ca.cust_account_id = to_number(p_object1_id1);
769:

Line 903: ,hz_cust_accounts_all ca

899: ,ca.party_id Party_ID
900: from
901: hz_cust_site_uses_all csu
902: ,hz_cust_acct_sites_all cas
903: ,hz_cust_accounts_all ca
904: where
905: csu.site_use_id = P_Bill_To_Site_Use_ID
906: and cas.cust_acct_site_id = csu.cust_acct_site_id
907: and ca.cust_account_id = cas.cust_account_id;

Line 913: hz_cust_accounts_all ca

909: CURSOR GetCustAcctParty IS
910: select
911: ca.party_id Party_ID
912: from
913: hz_cust_accounts_all ca
914: where ca.cust_account_id = P_Cust_Acct_ID;
915:
916: --Cursor to get Instrument_Assignment_ID
917: CURSOR GetInstrAssgnID IS