APPS.OKC_REP_SEARCH_UTIL_PVT dependencies on HZ_PARTIES

Line 893: -- c. Else get the party name from hz_parties using party_id join.

889: SELECT vendor_name
890: INTO l_party_name
891: FROM po_vendors
892: WHERE vendor_id = party_rec.party_id;
893: -- c. Else get the party name from hz_parties using party_id join.
894: ELSE
895: SELECT party_name
896: INTO l_party_name
897: FROM hz_parties

Line 897: FROM hz_parties

893: -- c. Else get the party name from hz_parties using party_id join.
894: ELSE
895: SELECT party_name
896: INTO l_party_name
897: FROM hz_parties
898: WHERE party_id = party_rec.party_id;
899: END IF;
900:
901: --c. Append party name from step a or b to x_parties.