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 246: okc_k_headers_b chr,

242: CURSOR l_rle_code_meaning_csr
243: IS
244: select fnd.meaning
245: from okc_subclass_roles sur,
246: okc_k_headers_b chr,
247: fnd_lookup_values fnd
248: where fnd.lookup_code = sur.rle_code
249: and sur.rle_code = p_rle_code
250: and fnd.lookup_type = 'OKC_ROLE'

Line 300: from okc_k_headers_b chr,

296:
297: select job.object_code OBJECT_CODE,job.object_code||'.ID1, '||job.object_code||'.ID2, '||
298: job.object_code||'.NAME, '||job.object_code||'.DESCRIPTION ' SELECT_CLAUSE,
299: from_table FROM_CLAUSE,where_clause WHERE_CLAUSE,order_by_clause ORDER_BY_CLAUSE
300: from okc_k_headers_b chr,
301: okc_subclass_rg_defs rgdfsrc,
302: OKC_RULE_DEF_SOURCES rdfsrc,
303: jtf_objects_b job
304: where job.object_code = rdfsrc.jtot_object_code

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

6786: l_api_name VARCHAR2(30) := 'validate_creditline';
6787: l_api_version CONSTANT NUMBER := 1.0;
6788:
6789: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
6790: l_chr_id okc_k_headers_b.id%type := null;
6791: l_mla_cl_id okc_k_headers_b.id%type := null;
6792: l_mla_id okc_k_headers_b.id%type := null;
6793: l_cl_k_no okc_k_headers_b.contract_number%type := null;
6794: l_cl_id okc_k_headers_b.id%type := null;

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

6787: l_api_version CONSTANT NUMBER := 1.0;
6788:
6789: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
6790: l_chr_id okc_k_headers_b.id%type := null;
6791: l_mla_cl_id okc_k_headers_b.id%type := null;
6792: l_mla_id okc_k_headers_b.id%type := null;
6793: l_cl_k_no okc_k_headers_b.contract_number%type := null;
6794: l_cl_id okc_k_headers_b.id%type := null;
6795: l_mla_no okc_k_headers_b.contract_number%type := null;

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

6788:
6789: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
6790: l_chr_id okc_k_headers_b.id%type := null;
6791: l_mla_cl_id okc_k_headers_b.id%type := null;
6792: l_mla_id okc_k_headers_b.id%type := null;
6793: l_cl_k_no okc_k_headers_b.contract_number%type := null;
6794: l_cl_id okc_k_headers_b.id%type := null;
6795: l_mla_no okc_k_headers_b.contract_number%type := null;
6796: l_fund_yn varchar2(1) := null;

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

6789: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
6790: l_chr_id okc_k_headers_b.id%type := null;
6791: l_mla_cl_id okc_k_headers_b.id%type := null;
6792: l_mla_id okc_k_headers_b.id%type := null;
6793: l_cl_k_no okc_k_headers_b.contract_number%type := null;
6794: l_cl_id okc_k_headers_b.id%type := null;
6795: l_mla_no okc_k_headers_b.contract_number%type := null;
6796: l_fund_yn varchar2(1) := null;
6797: l_mla_cl_yn varchar2(1) := null;

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

6790: l_chr_id okc_k_headers_b.id%type := null;
6791: l_mla_cl_id okc_k_headers_b.id%type := null;
6792: l_mla_id okc_k_headers_b.id%type := null;
6793: l_cl_k_no okc_k_headers_b.contract_number%type := null;
6794: l_cl_id okc_k_headers_b.id%type := null;
6795: l_mla_no okc_k_headers_b.contract_number%type := null;
6796: l_fund_yn varchar2(1) := null;
6797: l_mla_cl_yn varchar2(1) := null;
6798: l_yes varchar2(1) := null;

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

6791: l_mla_cl_id okc_k_headers_b.id%type := null;
6792: l_mla_id okc_k_headers_b.id%type := null;
6793: l_cl_k_no okc_k_headers_b.contract_number%type := null;
6794: l_cl_id okc_k_headers_b.id%type := null;
6795: l_mla_no okc_k_headers_b.contract_number%type := null;
6796: l_fund_yn varchar2(1) := null;
6797: l_mla_cl_yn varchar2(1) := null;
6798: l_yes varchar2(1) := null;
6799: l_cl_rev_yn okl_k_headers.revolving_credit_yn%type := null;

Line 6805: okc_k_headers_b chr,

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

Line 6806: okc_k_headers_b cl,

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

Line 6819: okc_k_headers_b mla,

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

Line 6820: okc_k_headers_b cl,

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

Line 6835: * okc_k_headers_b mla,

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

Line 6836: * okc_k_headers_b cl,

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

Line 6845: * from okc_k_headers_b chr,

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

Line 6858: okc_k_headers_b mla,

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

Line 6859: okc_k_headers_b cl,

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

Line 6882: from okc_k_headers_b cl1,

6878: and ap.trx_status_code in ('APPROVED', 'PROCESSED');
6879:
6880: cursor is_cl_revlvng_csr(l_cl_no in varchar2) is
6881: select khr.revolving_credit_yn
6882: from okc_k_headers_b cl1,
6883: okl_k_headers khr
6884: where cl1.scs_code = 'CREDITLINE_CONTRACT'
6885: and khr.id = cl1.id
6886: and cl1.contract_number = l_cl_no;

Line 6891: okc_k_headers_b mla,

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

Line 6892: okc_k_headers_b cl,

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

Line 7193: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;

7189:
7190: l_api_name VARCHAR2(30) := 'validate_deal';
7191: l_api_version CONSTANT NUMBER := 1.0;
7192:
7193: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
7194: -- Removed the assignment p_product_des from l_temp_yn
7195: l_temp_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
7196: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
7197: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;

Line 7195: l_temp_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;

7191: l_api_version CONSTANT NUMBER := 1.0;
7192:
7193: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
7194: -- Removed the assignment p_product_des from l_temp_yn
7195: l_temp_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
7196: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
7197: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
7198: l_object_code VARCHAR2(30) Default Null;
7199:

Line 7196: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;

7192:
7193: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
7194: -- Removed the assignment p_product_des from l_temp_yn
7195: l_temp_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
7196: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
7197: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
7198: l_object_code VARCHAR2(30) Default Null;
7199:
7200: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;

Line 7197: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;

7193: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
7194: -- Removed the assignment p_product_des from l_temp_yn
7195: l_temp_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
7196: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
7197: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
7198: l_object_code VARCHAR2(30) Default Null;
7199:
7200: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
7201: l_chr_id okl_k_headers_full_v.id%type;

Line 7236: and exists (select 1 from okc_k_headers_b

7232: where contract_number = p_program_no
7233: and scs_code = 'PROGRAM'
7234: and nvl(TEMPLATE_YN, 'N') = 'N'
7235: and sts_code = 'ACTIVE'
7236: and exists (select 1 from okc_k_headers_b
7237: where id = p_chr_id
7238: and authoring_org_id = prg_hdr.authoring_org_id);
7239:
7240: cursor l_credit_line_csr(p_curr_code VARCHAR2) is

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

7253:
7254:
7255: row_cnt number;
7256: l_orig_lse_object1_id1 okc_k_party_roles_b.object1_id1%type := null;
7257: l_re_book okc_k_headers_b.orig_system_source_code%type := null;
7258: l_orig_cust_acct_id okc_k_headers_b.cust_acct_id%type := null;
7259:
7260: cursor l_re_book_csr is
7261: select chr.orig_system_source_code, chr.cust_acct_id

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

7254:
7255: row_cnt number;
7256: l_orig_lse_object1_id1 okc_k_party_roles_b.object1_id1%type := null;
7257: l_re_book okc_k_headers_b.orig_system_source_code%type := null;
7258: l_orig_cust_acct_id okc_k_headers_b.cust_acct_id%type := null;
7259:
7260: cursor l_re_book_csr is
7261: select chr.orig_system_source_code, chr.cust_acct_id
7262: from OKC_K_HEADERS_B chr

Line 7262: from OKC_K_HEADERS_B chr

7258: l_orig_cust_acct_id okc_k_headers_b.cust_acct_id%type := null;
7259:
7260: cursor l_re_book_csr is
7261: select chr.orig_system_source_code, chr.cust_acct_id
7262: from OKC_K_HEADERS_B chr
7263: where chr.id = p_chr_id;
7264:
7265: cursor l_get_cust_csr is
7266: select object1_id1

Line 7286: FROM okc_k_headers_b chrb,

7282: l_template_type_code OKL_K_HEADERS.TEMPLATE_TYPE_CODE%TYPE := NULL;
7283: CURSOR l_tmpl_type_code_csr IS
7284: SELECT chrb.template_yn,
7285: khr.template_type_code
7286: FROM okc_k_headers_b chrb,
7287: okl_k_headers khr
7288: WHERE chrb.id = khr.id
7289: AND chrb.id = p_chr_id;
7290:

Line 8000: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;

7996: l_api_version CONSTANT NUMBER := 1.0;
7997:
7998:
7999:
8000: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
8001:
8002: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
8003:
8004: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;

Line 8002: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;

7998:
7999:
8000: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
8001:
8002: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
8003:
8004: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
8005:
8006: l_object_code VARCHAR2(30) Default Null;

Line 8004: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;

8000: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
8001:
8002: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
8003:
8004: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
8005:
8006: l_object_code VARCHAR2(30) Default Null;
8007:
8008:

Line 8174: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;

8170: l_api_version CONSTANT NUMBER := 1.0;
8171:
8172:
8173:
8174: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
8175:
8176: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
8177:
8178: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;

Line 8176: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;

8172:
8173:
8174: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
8175:
8176: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
8177:
8178: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
8179:
8180: l_object_code VARCHAR2(30) Default Null;

Line 8178: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;

8174: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
8175:
8176: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
8177:
8178: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
8179:
8180: l_object_code VARCHAR2(30) Default Null;
8181:
8182:

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

9389: ) AS
9390: l_api_name VARCHAR2(30) := 'validate_crdtln_wrng';
9391: l_api_version CONSTANT NUMBER := 1.0;
9392:
9393: l_mla_cl_gvr_id okc_k_headers_b.id%type := null;
9394: l_k_cl_gvr_id okc_k_headers_b.id%type := null;
9395: l_chr_id okc_k_headers_b.id%type := null;
9396:
9397: cursor is_k_cl_gvr_exsts_csr is

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

9390: l_api_name VARCHAR2(30) := 'validate_crdtln_wrng';
9391: l_api_version CONSTANT NUMBER := 1.0;
9392:
9393: l_mla_cl_gvr_id okc_k_headers_b.id%type := null;
9394: l_k_cl_gvr_id okc_k_headers_b.id%type := null;
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

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

9391: l_api_version CONSTANT NUMBER := 1.0;
9392:
9393: l_mla_cl_gvr_id okc_k_headers_b.id%type := null;
9394: l_k_cl_gvr_id okc_k_headers_b.id%type := null;
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,

Line 9400: okc_k_headers_b chr,

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

Line 9401: okc_k_headers_b cl

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

Line 9412: okc_k_headers_b chr,

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

Line 9413: okc_k_headers_b mla

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

Line 9422: okc_k_headers_b cl

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

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

9523: l_api_name VARCHAR2(30) := 'validate_crdtln_err';
9524: l_api_version CONSTANT NUMBER := 1.0;
9525:
9526: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
9527: l_chr_id okc_k_headers_b.id%type := null;
9528: l_k_cl_no okc_k_headers_b.contract_number%type := null;
9529: l_mla_no okc_k_headers_b.contract_number%type := null;
9530: l_deal_type okl_k_headers.deal_type%type := null;
9531:

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

9524: l_api_version CONSTANT NUMBER := 1.0;
9525:
9526: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
9527: l_chr_id okc_k_headers_b.id%type := null;
9528: l_k_cl_no okc_k_headers_b.contract_number%type := null;
9529: l_mla_no okc_k_headers_b.contract_number%type := null;
9530: l_deal_type okl_k_headers.deal_type%type := null;
9531:
9532: cursor get_deal_type_csr is

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

9525:
9526: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
9527: l_chr_id okc_k_headers_b.id%type := null;
9528: l_k_cl_no okc_k_headers_b.contract_number%type := null;
9529: l_mla_no okc_k_headers_b.contract_number%type := null;
9530: l_deal_type okl_k_headers.deal_type%type := null;
9531:
9532: cursor get_deal_type_csr is
9533: select chr.deal_type

Line 9540: okc_k_headers_b chr,

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

Line 9541: okc_k_headers_b cl

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

Line 9552: okc_k_headers_b chr,

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

Line 9553: okc_k_headers_b mla

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