APPS.OKC_REP_SEARCH_UTIL_PVT dependencies on HZ_PARTIES

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

883: SELECT vendor_name
884: INTO l_party_name
885: FROM po_vendors
886: WHERE vendor_id = party_rec.party_id;
887: -- c. Else get the party name from hz_parties using party_id join.
888: ELSE
889: SELECT party_name
890: INTO l_party_name
891: FROM hz_parties

Line 891: FROM hz_parties

887: -- c. Else get the party name from hz_parties using party_id join.
888: ELSE
889: SELECT party_name
890: INTO l_party_name
891: FROM hz_parties
892: WHERE party_id = party_rec.party_id;
893: END IF;
894:
895: --c. Append party name from step a or b to x_parties.