APPS.OKC_REP_UTIL_PVT dependencies on AP_SUPPLIERS

Line 1603: FROM ap_suppliers ap,

1599: WHERE UPPER(vendor_name) = UPPER(p_party_name);*/
1600:
1601: CURSOR vendor_exist_csr IS
1602: SELECT ap.vendor_id
1603: FROM ap_suppliers ap,
1604: hz_parties hp
1605: WHERE ap.party_id = hp.party_id
1606: AND UPPER(hp.party_name) = UPPER(p_party_name);
1607:

Line 1642: FROM ap_suppliers ap,

1638: AND vendor_id = p_party_id; */
1639:
1640: CURSOR vendor_and_role_csr IS
1641: SELECT 1
1642: FROM ap_suppliers ap,
1643: hz_parties hp
1644: WHERE UPPER(ap.vendor_name) = UPPER(p_party_name)
1645: AND hp.party_id = ap.party_id
1646: AND ap.vendor_id = p_party_id;