APPS.OKL_SERVICE_INTEGRATION_PVT dependencies on OKC_K_PARTY_ROLES_V

Line 440: FROM okc_k_party_roles_v role

436: WHERE id = p_chr_id;
437:
438: CURSOR okl_cust_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
439: SELECT role.object1_id1
440: FROM okc_k_party_roles_v role
441: WHERE role.chr_id = p_chr_id
442: AND role.rle_code = 'LESSEE';
443:
444: CURSOR okl_bill_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

Line 466: l_okl_customer_id OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE;

462:
463: l_okl_currency OKC_K_HEADERS_V.CURRENCY_CODE%TYPE;
464: l_oks_currency OKC_K_HEADERS_V.CURRENCY_CODE%TYPE;
465:
466: l_okl_customer_id OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE;
467: l_oks_customer_id OKL_LA_LINK_SERVICE_UV.CUSTOMER_ID%TYPE;
468:
469: l_okl_bill_to_id OKC_RULES_V.OBJECT1_ID1%TYPE;
470: l_oks_bill_to_id OKL_LA_LINK_SERVICE_UV.BILL_TO_ID%TYPE;