APPS.OKL_LA_VALIDATION_UTIL_PVT dependencies on OKC_GOVERNANCES

Line 6820: from okc_governances gvr,

6816: l_mla_cl_rev_yn okl_k_headers.revolving_credit_yn%type := null;
6817:
6818: cursor is_cl_exsts_csr is
6819: select cl.id, cl.contract_number
6820: from okc_governances gvr,
6821: okc_k_headers_b chr,
6822: okc_k_headers_b cl,
6823: okl_k_headers khr
6824: where chr.id = gvr.chr_id

Line 6834: from okc_governances gvr,

6830: and chr.id = p_chr_id;
6831:
6832: cursor is_mla_cl_yn_csr is
6833: select 'Y'
6834: from okc_governances gvr,
6835: okc_k_headers_b mla,
6836: okc_k_headers_b cl,
6837: okl_k_headers khr
6838: where mla.id = gvr.chr_id

Line 6850: * from okc_governances gvr,

6846: /* Bug 4502554
6847: *
6848: * cursor is_mla_cl_exsts_csr is
6849: * select cl.id, mla.contract_number, khr.revolving_credit_yn
6850: * from okc_governances gvr,
6851: * okc_k_headers_b mla,
6852: * okc_k_headers_b cl,
6853: * okl_k_headers khr
6854: * where mla.id = gvr.chr_id

Line 6862: * okc_governances mla_gvr

6858: * and cl.id = khr.id
6859: * and cl.scs_code = 'CREDITLINE_CONTRACT'
6860: * and exists ( select 1
6861: * from okc_k_headers_b chr,
6862: * okc_governances mla_gvr
6863: * where chr.id = mla_gvr.chr_id
6864: * and chr.id = mla_gvr.dnz_chr_id
6865: * and mla_gvr.cle_id is null
6866: * and mla_gvr.chr_id_referred = mla.id

Line 6873: from okc_governances gvr,

6869: */
6870: -- Modifed cursor, Bug 4502554
6871: cursor is_mla_cl_exsts_csr is
6872: select cl.id, mla.contract_number, khr.revolving_credit_yn
6873: from okc_governances gvr,
6874: okc_k_headers_b mla,
6875: okc_k_headers_b cl,
6876: okl_k_headers khr,
6877: okc_governances mla_gvr

Line 6877: okc_governances mla_gvr

6873: from okc_governances gvr,
6874: okc_k_headers_b mla,
6875: okc_k_headers_b cl,
6876: okl_k_headers khr,
6877: okc_governances mla_gvr
6878: where mla.id = gvr.chr_id
6879: and mla.id = gvr.dnz_chr_id
6880: and gvr.cle_id is null
6881: and gvr.chr_id_referred = cl.id

Line 6906: from okc_governances gvr,

6902: and cl1.contract_number = l_cl_no;
6903:
6904: cursor is_mla_cl_rev_yn_csr is
6905: select khr.revolving_credit_yn
6906: from okc_governances gvr,
6907: okc_k_headers_b mla,
6908: okc_k_headers_b cl,
6909: okl_k_headers khr
6910: where mla.id = gvr.chr_id

Line 9461: from okc_governances gvr,

9457: l_chr_id okc_k_headers_b.id%type := null;
9458:
9459: cursor is_k_cl_gvr_exsts_csr is
9460: select gvr.id
9461: from okc_governances gvr,
9462: okc_k_headers_b chr,
9463: okc_k_headers_b cl
9464: where chr.id = gvr.chr_id
9465: and chr.id = gvr.dnz_chr_id

Line 9473: from okc_governances gvr,

9469: and chr.id = p_chr_id;
9470:
9471: cursor is_mla_cl_gvr_exsts_csr is
9472: select gvr.id
9473: from okc_governances gvr,
9474: okc_k_headers_b chr,
9475: okc_k_headers_b mla
9476: where chr.id = gvr.chr_id
9477: and chr.id = gvr.dnz_chr_id

Line 9483: from okc_governances cl_gvr,

9479: and gvr.chr_id_referred = mla.id
9480: and mla.scs_code = 'MASTER_LEASE'
9481: and chr.id = p_chr_id
9482: and exists (select 1
9483: from okc_governances cl_gvr,
9484: okc_k_headers_b cl
9485: where cl_gvr.chr_id = mla.id
9486: and cl_gvr.cle_id is null
9487: and cl_gvr.chr_id_referred = cl.id

Line 9601: from okc_governances gvr,

9597: where chr.id = p_chr_id;
9598:
9599: cursor is_cl_exsts_csr is
9600: select cl.contract_number
9601: from okc_governances gvr,
9602: okc_k_headers_b chr,
9603: okc_k_headers_b cl
9604: where chr.id = gvr.chr_id
9605: and chr.id = gvr.dnz_chr_id

Line 9613: from okc_governances gvr,

9609: and chr.id = p_chr_id;
9610:
9611: cursor is_mla_exsts_csr is
9612: select mla.contract_number
9613: from okc_governances gvr,
9614: okc_k_headers_b chr,
9615: okc_k_headers_b mla
9616: where chr.id = gvr.chr_id
9617: and chr.id = gvr.dnz_chr_id