APPS.OKC_REP_UTIL_PVT dependencies on AP_SUPPLIERS

Line 1345: FROM ap_suppliers ap,

1341: WHERE UPPER(vendor_name) = UPPER(p_party_name);*/
1342:
1343: CURSOR vendor_exist_csr IS
1344: SELECT ap.vendor_id
1345: FROM ap_suppliers ap,
1346: hz_parties hp
1347: WHERE ap.party_id = hp.party_id
1348: AND UPPER(hp.party_name) = UPPER(p_party_name);
1349:

Line 1384: FROM ap_suppliers ap,

1380: AND vendor_id = p_party_id; */
1381:
1382: CURSOR vendor_and_role_csr IS
1383: SELECT 1
1384: FROM ap_suppliers ap,
1385: hz_parties hp
1386: WHERE UPPER(hp.party_name) = UPPER(p_party_name)
1387: AND hp.party_id = ap.party_id
1388: AND ap.vendor_id = p_party_id;