APPS.OKC_PO_QA_PVT dependencies on OKC_K_PARTY_ROLES_B

Line 329: FROM okc_k_party_roles_b cpr

325:
326: IF (x_return_status<>OKC_API.G_RET_STS_ERROR) THEN
327: SELECT count(*)
328: INTO lno_of_vendors
329: FROM okc_k_party_roles_b cpr
330: WHERE cpr.rle_code = 'VENDOR'
331: AND cpr.cle_id IS NULL -- header level vendors only
332: AND cpr.dnz_chr_id = p_chr_id;
333:

Line 348: FROM okc_k_party_roles_b cpr

344:
345:
346: SELECT count(*)
347: INTO lno_of_customers
348: FROM okc_k_party_roles_b cpr
349: WHERE cpr.rle_code = 'CUSTOMER'
350: AND cpr.cle_id IS NULL -- header level customers only
351: AND cpr.dnz_chr_id = p_chr_id;
352:

Line 371: okc_k_party_roles_b okpr

367: IF (x_return_status<>OKC_API.G_RET_STS_ERROR) THEN
368: SELECT 1 /*+ FIRST_ROWS */
369: INTO lbuyer_contact
370: FROM okc_contacts okcc,
371: okc_k_party_roles_b okpr
372: WHERE okcc.dnz_chr_id = okpr.dnz_chr_id
373: AND okcc.cro_code = 'BUYER'
374: AND okpr.rle_code = 'CUSTOMER'
375: AND okcc.dnz_chr_id = p_chr_id