DBA Data[Home] [Help]

APPS.OKS_MISC_UTIL_WEB dependencies on HZ_PARTIES

Line 945: FROM hz_parties party

941: AND mtl.organization_id = p_object1_id2;
942:
943: CURSOR get_party_name_csr IS
944: SELECT party.party_name
945: FROM hz_parties party
946: WHERE party.party_id = p_object1_id1;
947:
948: CURSOR get_system_name_csr IS
949: SELECT systl.name

Line 957: ,hz_parties p

953:
954: CURSOR get_account_name_csr IS
955: SELECT decode (ca.account_name, null, p.party_name,ca.account_name)
956: FROM hz_cust_accounts ca
957: ,hz_parties p
958: WHERE ca.cust_account_id = to_number(p_object1_id1)
959: AND p.party_id = ca.party_id;
960:
961: CURSOR get_site_name_csr IS