APPS.OKL_QA_DATA_INTEGRITY dependencies on PO_VENDORS

Line 3281: FROM okc_k_party_roles_b, po_vendors po

3277:
3278: --Find out all the vendors for the contract
3279: CURSOR chr_vendor_csr (p_chr_id IN NUMBER) IS
3280: SELECT object1_id1, po.vendor_name
3281: FROM okc_k_party_roles_b, po_vendors po
3282: WHERE chr_id = p_chr_id
3283: AND rle_code = 'OKL_VENDOR'
3284: AND po.vendor_id = object1_id1;
3285:

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

3396:
3397: --3. Disb basis for all vendors should be same
3398: CURSOR disb_basis_csr (p_chr_id IN NUMBER, p_cle_id IN NUMBER) IS
3399: SELECT ppy.disbursement_basis, po.vendor_name
3400: FROM okl_party_payment_dtls ppy, okl_party_payment_hdr pph, okc_k_party_roles_b rle, po_vendors po
3401: WHERE pph.dnz_chr_id = p_chr_id
3402: AND pph.cle_id = p_cle_id
3403: AND pph.id = ppy.payment_hdr_id
3404: AND ppy.cpl_id = rle.id

Line 3477: FROM po_vendors

3473: WHERE payment_hdr_id = p_payment_hdr_id;
3474:
3475: CURSOR vendor_csr(p_vendor_id IN NUMBER) IS
3476: SELECT vendor_name
3477: FROM po_vendors
3478: WHERE vendor_id = p_vendor_id;
3479:
3480: l_vendor_name po_vendors.vendor_name%TYPE;
3481: l_pct_sum NUMBER;

Line 3480: l_vendor_name po_vendors.vendor_name%TYPE;

3476: SELECT vendor_name
3477: FROM po_vendors
3478: WHERE vendor_id = p_vendor_id;
3479:
3480: l_vendor_name po_vendors.vendor_name%TYPE;
3481: l_pct_sum NUMBER;
3482: l_pth_dtl_present_yn VARCHAR2(1);
3483:
3484: --Bug#3877032

Line 8231: FROM po_vendors

8227: l_vendor_id OKC_K_PARTY_ROLES_B.OBJECT1_ID1%TYPE;
8228:
8229: CURSOR vendor_csr(p_vendor_id IN NUMBER) IS
8230: SELECT vendor_name
8231: FROM po_vendors
8232: WHERE vendor_id = p_vendor_id;
8233:
8234: l_vendor_name po_vendors.vendor_name%TYPE;
8235:

Line 8234: l_vendor_name po_vendors.vendor_name%TYPE;

8230: SELECT vendor_name
8231: FROM po_vendors
8232: WHERE vendor_id = p_vendor_id;
8233:
8234: l_vendor_name po_vendors.vendor_name%TYPE;
8235:
8236:
8237: CURSOR l_kle_csr(ltycode VARCHAR2, chrid OKL_K_HEADERS.KHR_ID%TYPE) IS
8238: SELECT NVL(kle.name,kle.item_description) name,