APPS.OKL_QA_DATA_INTEGRITY dependencies on OKC_K_PARTY_ROLES_B

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 8106: FROM okc_k_party_roles_b

8102:
8103: CURSOR party_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE,
8104: p_cle_id OKC_K_LINES_B.ID%TYPE) IS
8105: SELECT object1_id1
8106: FROM okc_k_party_roles_b
8107: WHERE dnz_chr_id = p_chr_id
8108: AND cle_id = p_cle_id
8109: AND jtot_object1_code = 'OKX_VENDOR';
8110:

Line 8156: l_passthru_vendor_id OKC_K_PARTY_ROLES_B.OBJECT1_ID1%TYPE;

8152:
8153: l_tot_sub_line_amt NUMBER;
8154:
8155: l_passthru_site_id OKC_RULES_B.OBJECT1_ID1%TYPE;
8156: l_passthru_vendor_id OKC_K_PARTY_ROLES_B.OBJECT1_ID1%TYPE;
8157: l_site_valid VARCHAR2(1) := '?';
8158: l_passthru_present VARCHAR2(1) := 'N';
8159:
8160: lx_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 8227: l_vendor_id OKC_K_PARTY_ROLES_B.OBJECT1_ID1%TYPE;

8223: WHERE pph.cle_id = p_cle_id
8224: AND pph.dnz_chr_id = p_chr_id
8225: AND ppd.payment_hdr_id = pph.id;
8226:
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

Line 11591: okc_k_party_roles_b cplb,

11587:
11588: CURSOR check_refund_details(p_subsidy_cle_id NUMBER) IS
11589: SELECT pyd.vendor_id
11590: FROM okl_party_payment_dtls pyd,
11591: okc_k_party_roles_b cplb,
11592: okc_k_lines_b cleb
11593: WHERE pyd.cpl_id = cplb.id
11594: AND cplb.cle_id = cleb.id
11595: AND cplb.chr_id IS NULL