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
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