eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_LA_VALIDATION_UTIL_PVT dependencies on OKC_K_HEADERS_B

Line 262: okc_k_headers_b chr,

258: CURSOR l_rle_code_meaning_csr
259: IS
260: select fnd.meaning
261: from okc_subclass_roles sur,
262: okc_k_headers_b chr,
263: fnd_lookup_values fnd
264: where fnd.lookup_code = sur.rle_code
265: and sur.rle_code = p_rle_code
266: and fnd.lookup_type = 'OKC_ROLE'

Line 316: from okc_k_headers_b chr,

312:
313: select job.object_code OBJECT_CODE,job.object_code||'.ID1, '||job.object_code||'.ID2, '||
314: job.object_code||'.NAME, '||job.object_code||'.DESCRIPTION ' SELECT_CLAUSE,
315: from_table FROM_CLAUSE,where_clause WHERE_CLAUSE,order_by_clause ORDER_BY_CLAUSE
316: from okc_k_headers_b chr,
317: okc_subclass_rg_defs rgdfsrc,
318: OKC_RULE_DEF_SOURCES rdfsrc,
319: jtf_objects_b job
320: where job.object_code = rdfsrc.jtot_object_code

Line 6806: l_chr_id okc_k_headers_b.id%type := null;

6802: l_api_name VARCHAR2(30) := 'validate_creditline';
6803: l_api_version CONSTANT NUMBER := 1.0;
6804:
6805: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
6806: l_chr_id okc_k_headers_b.id%type := null;
6807: l_mla_cl_id okc_k_headers_b.id%type := null;
6808: l_mla_id okc_k_headers_b.id%type := null;
6809: l_cl_k_no okc_k_headers_b.contract_number%type := null;
6810: l_cl_id okc_k_headers_b.id%type := null;

Line 6807: l_mla_cl_id okc_k_headers_b.id%type := null;

6803: l_api_version CONSTANT NUMBER := 1.0;
6804:
6805: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
6806: l_chr_id okc_k_headers_b.id%type := null;
6807: l_mla_cl_id okc_k_headers_b.id%type := null;
6808: l_mla_id okc_k_headers_b.id%type := null;
6809: l_cl_k_no okc_k_headers_b.contract_number%type := null;
6810: l_cl_id okc_k_headers_b.id%type := null;
6811: l_mla_no okc_k_headers_b.contract_number%type := null;

Line 6808: l_mla_id okc_k_headers_b.id%type := null;

6804:
6805: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
6806: l_chr_id okc_k_headers_b.id%type := null;
6807: l_mla_cl_id okc_k_headers_b.id%type := null;
6808: l_mla_id okc_k_headers_b.id%type := null;
6809: l_cl_k_no okc_k_headers_b.contract_number%type := null;
6810: l_cl_id okc_k_headers_b.id%type := null;
6811: l_mla_no okc_k_headers_b.contract_number%type := null;
6812: l_fund_yn varchar2(1) := null;

Line 6809: l_cl_k_no okc_k_headers_b.contract_number%type := null;

6805: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
6806: l_chr_id okc_k_headers_b.id%type := null;
6807: l_mla_cl_id okc_k_headers_b.id%type := null;
6808: l_mla_id okc_k_headers_b.id%type := null;
6809: l_cl_k_no okc_k_headers_b.contract_number%type := null;
6810: l_cl_id okc_k_headers_b.id%type := null;
6811: l_mla_no okc_k_headers_b.contract_number%type := null;
6812: l_fund_yn varchar2(1) := null;
6813: l_mla_cl_yn varchar2(1) := null;

Line 6810: l_cl_id okc_k_headers_b.id%type := null;

6806: l_chr_id okc_k_headers_b.id%type := null;
6807: l_mla_cl_id okc_k_headers_b.id%type := null;
6808: l_mla_id okc_k_headers_b.id%type := null;
6809: l_cl_k_no okc_k_headers_b.contract_number%type := null;
6810: l_cl_id okc_k_headers_b.id%type := null;
6811: l_mla_no okc_k_headers_b.contract_number%type := null;
6812: l_fund_yn varchar2(1) := null;
6813: l_mla_cl_yn varchar2(1) := null;
6814: l_yes varchar2(1) := null;

Line 6811: l_mla_no okc_k_headers_b.contract_number%type := null;

6807: l_mla_cl_id okc_k_headers_b.id%type := null;
6808: l_mla_id okc_k_headers_b.id%type := null;
6809: l_cl_k_no okc_k_headers_b.contract_number%type := null;
6810: l_cl_id okc_k_headers_b.id%type := null;
6811: l_mla_no okc_k_headers_b.contract_number%type := null;
6812: l_fund_yn varchar2(1) := null;
6813: l_mla_cl_yn varchar2(1) := null;
6814: l_yes varchar2(1) := null;
6815: l_cl_rev_yn okl_k_headers.revolving_credit_yn%type := null;

Line 6821: okc_k_headers_b chr,

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
6825: and chr.id = gvr.dnz_chr_id

Line 6822: okc_k_headers_b cl,

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
6825: and chr.id = gvr.dnz_chr_id
6826: and gvr.cle_id is null

Line 6835: okc_k_headers_b mla,

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
6839: and mla.id = gvr.dnz_chr_id

Line 6836: okc_k_headers_b cl,

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
6839: and mla.id = gvr.dnz_chr_id
6840: and gvr.cle_id is null

Line 6851: * okc_k_headers_b mla,

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
6855: * and mla.id = gvr.dnz_chr_id

Line 6852: * okc_k_headers_b cl,

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
6855: * and mla.id = gvr.dnz_chr_id
6856: * and gvr.cle_id is null

Line 6861: * from okc_k_headers_b chr,

6857: * and gvr.chr_id_referred = cl.id
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

Line 6874: okc_k_headers_b mla,

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
6878: where mla.id = gvr.chr_id

Line 6875: okc_k_headers_b cl,

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
6878: where mla.id = gvr.chr_id
6879: and mla.id = gvr.dnz_chr_id

Line 6898: from okc_k_headers_b cl1,

6894: and ap.trx_status_code in ('APPROVED', 'PROCESSED');
6895:
6896: cursor is_cl_revlvng_csr(l_cl_no in varchar2) is
6897: select khr.revolving_credit_yn
6898: from okc_k_headers_b cl1,
6899: okl_k_headers khr
6900: where cl1.scs_code = 'CREDITLINE_CONTRACT'
6901: and khr.id = cl1.id
6902: and cl1.contract_number = l_cl_no;

Line 6907: okc_k_headers_b mla,

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
6911: and mla.id = gvr.dnz_chr_id

Line 6908: okc_k_headers_b cl,

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
6911: and mla.id = gvr.dnz_chr_id
6912: and gvr.cle_id is null

Line 7209: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;

7205:
7206: l_api_name VARCHAR2(30) := 'validate_deal';
7207: l_api_version CONSTANT NUMBER := 1.0;
7208:
7209: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
7210: -- Removed the assignment p_product_des from l_temp_yn
7211: l_temp_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
7212: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
7213: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;

Line 7211: l_temp_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;

7207: l_api_version CONSTANT NUMBER := 1.0;
7208:
7209: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
7210: -- Removed the assignment p_product_des from l_temp_yn
7211: l_temp_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
7212: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
7213: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
7214: l_object_code VARCHAR2(30) Default Null;
7215:

Line 7212: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;

7208:
7209: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
7210: -- Removed the assignment p_product_des from l_temp_yn
7211: l_temp_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
7212: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
7213: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
7214: l_object_code VARCHAR2(30) Default Null;
7215:
7216: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;

Line 7213: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;

7209: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
7210: -- Removed the assignment p_product_des from l_temp_yn
7211: l_temp_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
7212: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
7213: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
7214: l_object_code VARCHAR2(30) Default Null;
7215:
7216: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
7217: l_chr_id okl_k_headers_full_v.id%type;

Line 7252: and exists (select 1 from okc_k_headers_b

7248: where contract_number = p_program_no
7249: and scs_code = 'PROGRAM'
7250: and nvl(TEMPLATE_YN, 'N') = 'N'
7251: and sts_code = 'ACTIVE'
7252: and exists (select 1 from okc_k_headers_b
7253: where id = p_chr_id
7254: and authoring_org_id = prg_hdr.authoring_org_id);
7255:
7256: cursor l_credit_line_csr(p_curr_code VARCHAR2) is

Line 7273: l_re_book okc_k_headers_b.orig_system_source_code%type := null;

7269:
7270:
7271: row_cnt number;
7272: l_orig_lse_object1_id1 okc_k_party_roles_b.object1_id1%type := null;
7273: l_re_book okc_k_headers_b.orig_system_source_code%type := null;
7274: l_orig_cust_acct_id okc_k_headers_b.cust_acct_id%type := null;
7275:
7276: cursor l_re_book_csr is
7277: select chr.orig_system_source_code, chr.cust_acct_id

Line 7274: l_orig_cust_acct_id okc_k_headers_b.cust_acct_id%type := null;

7270:
7271: row_cnt number;
7272: l_orig_lse_object1_id1 okc_k_party_roles_b.object1_id1%type := null;
7273: l_re_book okc_k_headers_b.orig_system_source_code%type := null;
7274: l_orig_cust_acct_id okc_k_headers_b.cust_acct_id%type := null;
7275:
7276: cursor l_re_book_csr is
7277: select chr.orig_system_source_code, chr.cust_acct_id
7278: from OKC_K_HEADERS_B chr

Line 7278: from OKC_K_HEADERS_B chr

7274: l_orig_cust_acct_id okc_k_headers_b.cust_acct_id%type := null;
7275:
7276: cursor l_re_book_csr is
7277: select chr.orig_system_source_code, chr.cust_acct_id
7278: from OKC_K_HEADERS_B chr
7279: where chr.id = p_chr_id;
7280:
7281: cursor l_get_cust_csr is
7282: select object1_id1

Line 7302: FROM okc_k_headers_b chrb,

7298: l_template_type_code OKL_K_HEADERS.TEMPLATE_TYPE_CODE%TYPE := NULL;
7299: CURSOR l_tmpl_type_code_csr IS
7300: SELECT chrb.template_yn,
7301: khr.template_type_code
7302: FROM okc_k_headers_b chrb,
7303: okl_k_headers khr
7304: WHERE chrb.id = khr.id
7305: AND chrb.id = p_chr_id;
7306:

Line 8062: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;

8058: l_api_version CONSTANT NUMBER := 1.0;
8059:
8060:
8061:
8062: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
8063:
8064: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
8065:
8066: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;

Line 8064: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;

8060:
8061:
8062: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
8063:
8064: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
8065:
8066: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
8067:
8068: l_object_code VARCHAR2(30) Default Null;

Line 8066: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;

8062: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
8063:
8064: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
8065:
8066: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
8067:
8068: l_object_code VARCHAR2(30) Default Null;
8069:
8070:

Line 8236: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;

8232: l_api_version CONSTANT NUMBER := 1.0;
8233:
8234:
8235:
8236: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
8237:
8238: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
8239:
8240: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;

Line 8238: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;

8234:
8235:
8236: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
8237:
8238: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
8239:
8240: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
8241:
8242: l_object_code VARCHAR2(30) Default Null;

Line 8240: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;

8236: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
8237:
8238: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
8239:
8240: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
8241:
8242: l_object_code VARCHAR2(30) Default Null;
8243:
8244:

Line 9455: l_mla_cl_gvr_id okc_k_headers_b.id%type := null;

9451: ) AS
9452: l_api_name VARCHAR2(30) := 'validate_crdtln_wrng';
9453: l_api_version CONSTANT NUMBER := 1.0;
9454:
9455: l_mla_cl_gvr_id okc_k_headers_b.id%type := null;
9456: l_k_cl_gvr_id okc_k_headers_b.id%type := null;
9457: l_chr_id okc_k_headers_b.id%type := null;
9458:
9459: cursor is_k_cl_gvr_exsts_csr is

Line 9456: l_k_cl_gvr_id okc_k_headers_b.id%type := null;

9452: l_api_name VARCHAR2(30) := 'validate_crdtln_wrng';
9453: l_api_version CONSTANT NUMBER := 1.0;
9454:
9455: l_mla_cl_gvr_id okc_k_headers_b.id%type := null;
9456: l_k_cl_gvr_id okc_k_headers_b.id%type := null;
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

Line 9457: l_chr_id okc_k_headers_b.id%type := null;

9453: l_api_version CONSTANT NUMBER := 1.0;
9454:
9455: l_mla_cl_gvr_id okc_k_headers_b.id%type := null;
9456: l_k_cl_gvr_id okc_k_headers_b.id%type := null;
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,

Line 9462: okc_k_headers_b chr,

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
9466: and gvr.cle_id is null

Line 9463: okc_k_headers_b cl

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
9466: and gvr.cle_id is null
9467: and gvr.chr_id_referred = cl.id

Line 9474: okc_k_headers_b chr,

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
9478: and gvr.cle_id is null

Line 9475: okc_k_headers_b mla

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
9478: and gvr.cle_id is null
9479: and gvr.chr_id_referred = mla.id

Line 9484: okc_k_headers_b cl

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
9488: and cl.scs_code = 'CREDITLINE_CONTRACT'

Line 9589: l_chr_id okc_k_headers_b.id%type := null;

9585: l_api_name VARCHAR2(30) := 'validate_crdtln_err';
9586: l_api_version CONSTANT NUMBER := 1.0;
9587:
9588: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
9589: l_chr_id okc_k_headers_b.id%type := null;
9590: l_k_cl_no okc_k_headers_b.contract_number%type := null;
9591: l_mla_no okc_k_headers_b.contract_number%type := null;
9592: l_deal_type okl_k_headers.deal_type%type := null;
9593:

Line 9590: l_k_cl_no okc_k_headers_b.contract_number%type := null;

9586: l_api_version CONSTANT NUMBER := 1.0;
9587:
9588: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
9589: l_chr_id okc_k_headers_b.id%type := null;
9590: l_k_cl_no okc_k_headers_b.contract_number%type := null;
9591: l_mla_no okc_k_headers_b.contract_number%type := null;
9592: l_deal_type okl_k_headers.deal_type%type := null;
9593:
9594: cursor get_deal_type_csr is

Line 9591: l_mla_no okc_k_headers_b.contract_number%type := null;

9587:
9588: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
9589: l_chr_id okc_k_headers_b.id%type := null;
9590: l_k_cl_no okc_k_headers_b.contract_number%type := null;
9591: l_mla_no okc_k_headers_b.contract_number%type := null;
9592: l_deal_type okl_k_headers.deal_type%type := null;
9593:
9594: cursor get_deal_type_csr is
9595: select chr.deal_type

Line 9602: okc_k_headers_b chr,

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
9606: and gvr.cle_id is null

Line 9603: okc_k_headers_b cl

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
9606: and gvr.cle_id is null
9607: and gvr.chr_id_referred = cl.id

Line 9614: okc_k_headers_b chr,

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
9618: and gvr.cle_id is null

Line 9615: okc_k_headers_b mla

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
9618: and gvr.cle_id is null
9619: and gvr.chr_id_referred = mla.id