APPS.OKL_QA_DATA_INTEGRITY dependencies on PO_VENDORS

Line 3124: FROM okc_k_party_roles_b, po_vendors po

3120:
3121: --Find out all the vendors for the contract
3122: CURSOR chr_vendor_csr (p_chr_id IN NUMBER) IS
3123: SELECT object1_id1, po.vendor_name
3124: FROM okc_k_party_roles_b, po_vendors po
3125: WHERE chr_id = p_chr_id
3126: AND rle_code = 'OKL_VENDOR'
3127: AND po.vendor_id = object1_id1;
3128:

Line 3215: FROM okl_party_payment_dtls ppy, okl_party_payment_hdr pph, okc_k_party_roles_b rle, po_vendors po

3211:
3212: --3. Disb basis for all vendors should be same
3213: CURSOR disb_basis_csr (p_chr_id IN NUMBER, p_cle_id IN NUMBER) IS
3214: SELECT ppy.disbursement_basis, po.vendor_name
3215: FROM okl_party_payment_dtls ppy, okl_party_payment_hdr pph, okc_k_party_roles_b rle, po_vendors po
3216: WHERE pph.dnz_chr_id = p_chr_id
3217: AND pph.cle_id = p_cle_id
3218: AND pph.id = ppy.payment_hdr_id
3219: AND ppy.cpl_id = rle.id

Line 3292: FROM po_vendors

3288: WHERE payment_hdr_id = p_payment_hdr_id;
3289:
3290: CURSOR vendor_csr(p_vendor_id IN NUMBER) IS
3291: SELECT vendor_name
3292: FROM po_vendors
3293: WHERE vendor_id = p_vendor_id;
3294:
3295: l_vendor_name po_vendors.vendor_name%TYPE;
3296: l_pct_sum NUMBER;

Line 3295: l_vendor_name po_vendors.vendor_name%TYPE;

3291: SELECT vendor_name
3292: FROM po_vendors
3293: WHERE vendor_id = p_vendor_id;
3294:
3295: l_vendor_name po_vendors.vendor_name%TYPE;
3296: l_pct_sum NUMBER;
3297: l_pth_dtl_present_yn VARCHAR2(1);
3298:
3299: --Bug#3877032

Line 7814: FROM po_vendors

7810: l_vendor_id OKC_K_PARTY_ROLES_B.OBJECT1_ID1%TYPE;
7811:
7812: CURSOR vendor_csr(p_vendor_id IN NUMBER) IS
7813: SELECT vendor_name
7814: FROM po_vendors
7815: WHERE vendor_id = p_vendor_id;
7816:
7817: l_vendor_name po_vendors.vendor_name%TYPE;
7818:

Line 7817: l_vendor_name po_vendors.vendor_name%TYPE;

7813: SELECT vendor_name
7814: FROM po_vendors
7815: WHERE vendor_id = p_vendor_id;
7816:
7817: l_vendor_name po_vendors.vendor_name%TYPE;
7818:
7819:
7820: CURSOR l_kle_csr(ltycode VARCHAR2, chrid OKL_K_HEADERS.KHR_ID%TYPE) IS
7821: SELECT NVL(kle.name,kle.item_description) name,