APPS.OKS_UTIL_PUB dependencies on HZ_PARTIES

Line 746: FROM hz_parties

742:
743: -- Covered Parties
744: CURSOR partycur IS
745: SELECT party_name name
746: FROM hz_parties
747: WHERE party_id = to_number(p_object1_id1);
748:
749: -- Covered Sites
750: CURSOR sitecur IS

Line 766: hz_parties p

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:
770: -- Usage Items(Counters)