APPS.OKL_LA_VALIDATION_UTIL_PVT dependencies on OKC_GOVERNANCES

Line 6804: from okc_governances gvr,

6800: l_mla_cl_rev_yn okl_k_headers.revolving_credit_yn%type := null;
6801:
6802: cursor is_cl_exsts_csr is
6803: select cl.id, cl.contract_number
6804: from okc_governances gvr,
6805: okc_k_headers_b chr,
6806: okc_k_headers_b cl,
6807: okl_k_headers khr
6808: where chr.id = gvr.chr_id

Line 6818: from okc_governances gvr,

6814: and chr.id = p_chr_id;
6815:
6816: cursor is_mla_cl_yn_csr is
6817: select 'Y'
6818: from okc_governances gvr,
6819: okc_k_headers_b mla,
6820: okc_k_headers_b cl,
6821: okl_k_headers khr
6822: where mla.id = gvr.chr_id

Line 6834: * from okc_governances gvr,

6830: /* Bug 4502554
6831: *
6832: * cursor is_mla_cl_exsts_csr is
6833: * select cl.id, mla.contract_number, khr.revolving_credit_yn
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 6846: * okc_governances mla_gvr

6842: * and cl.id = khr.id
6843: * and cl.scs_code = 'CREDITLINE_CONTRACT'
6844: * and exists ( select 1
6845: * from okc_k_headers_b chr,
6846: * okc_governances mla_gvr
6847: * where chr.id = mla_gvr.chr_id
6848: * and chr.id = mla_gvr.dnz_chr_id
6849: * and mla_gvr.cle_id is null
6850: * and mla_gvr.chr_id_referred = mla.id

Line 6857: from okc_governances gvr,

6853: */
6854: -- Modifed cursor, Bug 4502554
6855: cursor is_mla_cl_exsts_csr is
6856: select cl.id, mla.contract_number, khr.revolving_credit_yn
6857: from okc_governances gvr,
6858: okc_k_headers_b mla,
6859: okc_k_headers_b cl,
6860: okl_k_headers khr,
6861: okc_governances mla_gvr

Line 6861: okc_governances mla_gvr

6857: from okc_governances gvr,
6858: okc_k_headers_b mla,
6859: okc_k_headers_b cl,
6860: okl_k_headers khr,
6861: okc_governances mla_gvr
6862: where mla.id = gvr.chr_id
6863: and mla.id = gvr.dnz_chr_id
6864: and gvr.cle_id is null
6865: and gvr.chr_id_referred = cl.id

Line 6890: from okc_governances gvr,

6886: and cl1.contract_number = l_cl_no;
6887:
6888: cursor is_mla_cl_rev_yn_csr is
6889: select khr.revolving_credit_yn
6890: from okc_governances gvr,
6891: okc_k_headers_b mla,
6892: okc_k_headers_b cl,
6893: okl_k_headers khr
6894: where mla.id = gvr.chr_id

Line 9399: from okc_governances gvr,

9395: l_chr_id okc_k_headers_b.id%type := null;
9396:
9397: cursor is_k_cl_gvr_exsts_csr is
9398: select gvr.id
9399: from okc_governances gvr,
9400: okc_k_headers_b chr,
9401: okc_k_headers_b cl
9402: where chr.id = gvr.chr_id
9403: and chr.id = gvr.dnz_chr_id

Line 9411: from okc_governances gvr,

9407: and chr.id = p_chr_id;
9408:
9409: cursor is_mla_cl_gvr_exsts_csr is
9410: select gvr.id
9411: from okc_governances gvr,
9412: okc_k_headers_b chr,
9413: okc_k_headers_b mla
9414: where chr.id = gvr.chr_id
9415: and chr.id = gvr.dnz_chr_id

Line 9421: from okc_governances cl_gvr,

9417: and gvr.chr_id_referred = mla.id
9418: and mla.scs_code = 'MASTER_LEASE'
9419: and chr.id = p_chr_id
9420: and exists (select 1
9421: from okc_governances cl_gvr,
9422: okc_k_headers_b cl
9423: where cl_gvr.chr_id = mla.id
9424: and cl_gvr.cle_id is null
9425: and cl_gvr.chr_id_referred = cl.id

Line 9539: from okc_governances gvr,

9535: where chr.id = p_chr_id;
9536:
9537: cursor is_cl_exsts_csr is
9538: select cl.contract_number
9539: from okc_governances gvr,
9540: okc_k_headers_b chr,
9541: okc_k_headers_b cl
9542: where chr.id = gvr.chr_id
9543: and chr.id = gvr.dnz_chr_id

Line 9551: from okc_governances gvr,

9547: and chr.id = p_chr_id;
9548:
9549: cursor is_mla_exsts_csr is
9550: select mla.contract_number
9551: from okc_governances gvr,
9552: okc_k_headers_b chr,
9553: okc_k_headers_b mla
9554: where chr.id = gvr.chr_id
9555: and chr.id = gvr.dnz_chr_id