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_CREATE_KLE_PVT dependencies on OKC_K_HEADERS_B

Line 101: FROM OKC_K_HEADERS_B

97: ---------------------------------------------------------------------------------------------------------------
98: --Added by dpsingh for LE uptake
99: CURSOR contract_num_csr (p_ctr_id1 NUMBER) IS
100: SELECT contract_number
101: FROM OKC_K_HEADERS_B
102: WHERE id = p_ctr_id1;
103:
104: FUNCTION is_duplicate_serial_number(p_serial_number OKL_TXL_ITM_INSTS.SERIAL_NUMBER%TYPE,
105: p_item_id OKL_TXL_ITM_INSTS.INVENTORY_ITEM_ID%TYPE)

Line 328: x_sts_code OUT NOCOPY OKC_K_HEADERS_B.STS_CODE%TYPE)

324: END generate_asset_number;
325: ----------------------------------------------------------------------------------------------------------
326: FUNCTION get_sts_code(p_dnz_chr_id IN OKC_K_LINES_B.DNZ_CHR_ID%TYPE DEFAULT OKL_API.G_MISS_NUM,
327: p_cle_id IN OKC_K_LINES_B.CLE_ID%TYPE DEFAULT OKL_API.G_MISS_NUM,
328: x_sts_code OUT NOCOPY OKC_K_HEADERS_B.STS_CODE%TYPE)
329: RETURN VARCHAR2 IS
330: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
331: CURSOR c_get_tls_sts_code(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
332: SELECT chrv.sts_code

Line 440: x_end_date OUT NOCOPY OKC_K_HEADERS_B.END_DATE%TYPE)

436: END get_sts_code;
437: ----------------------------------------------------------------------------------------------------------------
438: FUNCTION get_end_date(p_dnz_chr_id IN OKC_K_LINES_B.DNZ_CHR_ID%TYPE DEFAULT OKL_API.G_MISS_NUM,
439: p_cle_id IN OKC_K_LINES_B.CLE_ID%TYPE DEFAULT OKL_API.G_MISS_NUM,
440: x_end_date OUT NOCOPY OKC_K_HEADERS_B.END_DATE%TYPE)
441: RETURN VARCHAR2 IS
442: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
443: CURSOR c_get_tls_end_date(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
444: SELECT chrv.end_Date

Line 536: x_start_date OUT NOCOPY OKC_K_HEADERS_B.START_DATE%TYPE)

532: END get_end_date;
533: ----------------------------------------------------------------------------------------------------------------
534: FUNCTION get_start_date(p_dnz_chr_id IN OKC_K_LINES_B.DNZ_CHR_ID%TYPE DEFAULT OKL_API.G_MISS_NUM,
535: p_cle_id IN OKC_K_LINES_B.CLE_ID%TYPE DEFAULT OKL_API.G_MISS_NUM,
536: x_start_date OUT NOCOPY OKC_K_HEADERS_B.START_DATE%TYPE)
537: RETURN VARCHAR2 IS
538: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
539: lv_orig_sys_source_code OKC_K_HEADERS_B.ORIG_SYSTEM_SOURCE_CODE%TYPE;
540: ln_orig_system_id1 OKC_K_HEADERS_B.ORIG_SYSTEM_ID1%TYPE;

Line 539: lv_orig_sys_source_code OKC_K_HEADERS_B.ORIG_SYSTEM_SOURCE_CODE%TYPE;

535: p_cle_id IN OKC_K_LINES_B.CLE_ID%TYPE DEFAULT OKL_API.G_MISS_NUM,
536: x_start_date OUT NOCOPY OKC_K_HEADERS_B.START_DATE%TYPE)
537: RETURN VARCHAR2 IS
538: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
539: lv_orig_sys_source_code OKC_K_HEADERS_B.ORIG_SYSTEM_SOURCE_CODE%TYPE;
540: ln_orig_system_id1 OKC_K_HEADERS_B.ORIG_SYSTEM_ID1%TYPE;
541: ld_start_date OKC_K_LINES_B.START_DATE%TYPE;
542: CURSOR c_get_tls_start_date(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
543: SELECT chrv.start_Date,

Line 540: ln_orig_system_id1 OKC_K_HEADERS_B.ORIG_SYSTEM_ID1%TYPE;

536: x_start_date OUT NOCOPY OKC_K_HEADERS_B.START_DATE%TYPE)
537: RETURN VARCHAR2 IS
538: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
539: lv_orig_sys_source_code OKC_K_HEADERS_B.ORIG_SYSTEM_SOURCE_CODE%TYPE;
540: ln_orig_system_id1 OKC_K_HEADERS_B.ORIG_SYSTEM_ID1%TYPE;
541: ld_start_date OKC_K_LINES_B.START_DATE%TYPE;
542: CURSOR c_get_tls_start_date(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
543: SELECT chrv.start_Date,
544: chrv.orig_system_source_code,

Line 655: x_currency_code OUT NOCOPY OKC_K_HEADERS_B.CURRENCY_CODE%TYPE)

651: END get_start_date;
652: ----------------------------------------------------------------------------------------------------------------
653: FUNCTION get_currency_code(p_dnz_chr_id IN OKC_K_LINES_B.DNZ_CHR_ID%TYPE DEFAULT OKL_API.G_MISS_NUM,
654: p_cle_id IN OKC_K_LINES_B.CLE_ID%TYPE DEFAULT OKL_API.G_MISS_NUM,
655: x_currency_code OUT NOCOPY OKC_K_HEADERS_B.CURRENCY_CODE%TYPE)
656: RETURN VARCHAR2 IS
657: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
658: CURSOR c_get_tls_currency_code(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
659: SELECT chrv.currency_code

Line 763: lv_orig_sys_source_code OKC_K_HEADERS_B.ORIG_SYSTEM_SOURCE_CODE%TYPE;

759: p_cle_id IN OKC_K_LINES_B.CLE_ID%TYPE DEFAULT OKL_API.G_MISS_NUM,
760: p_clev_rec IN OUT NOCOPY clev_rec_type)
761: RETURN VARCHAR2 IS
762: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
763: lv_orig_sys_source_code OKC_K_HEADERS_B.ORIG_SYSTEM_SOURCE_CODE%TYPE;
764: ln_orig_system_id1 OKC_K_HEADERS_B.ORIG_SYSTEM_ID1%TYPE;
765: ld_start_date OKC_K_LINES_B.START_DATE%TYPE;
766: ld_end_date OKC_K_LINES_B.END_DATE%TYPE;
767: lv_currency_code OKC_K_HEADERS_B.CURRENCY_CODE%TYPE;

Line 764: ln_orig_system_id1 OKC_K_HEADERS_B.ORIG_SYSTEM_ID1%TYPE;

760: p_clev_rec IN OUT NOCOPY clev_rec_type)
761: RETURN VARCHAR2 IS
762: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
763: lv_orig_sys_source_code OKC_K_HEADERS_B.ORIG_SYSTEM_SOURCE_CODE%TYPE;
764: ln_orig_system_id1 OKC_K_HEADERS_B.ORIG_SYSTEM_ID1%TYPE;
765: ld_start_date OKC_K_LINES_B.START_DATE%TYPE;
766: ld_end_date OKC_K_LINES_B.END_DATE%TYPE;
767: lv_currency_code OKC_K_HEADERS_B.CURRENCY_CODE%TYPE;
768: lv_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;

Line 767: lv_currency_code OKC_K_HEADERS_B.CURRENCY_CODE%TYPE;

763: lv_orig_sys_source_code OKC_K_HEADERS_B.ORIG_SYSTEM_SOURCE_CODE%TYPE;
764: ln_orig_system_id1 OKC_K_HEADERS_B.ORIG_SYSTEM_ID1%TYPE;
765: ld_start_date OKC_K_LINES_B.START_DATE%TYPE;
766: ld_end_date OKC_K_LINES_B.END_DATE%TYPE;
767: lv_currency_code OKC_K_HEADERS_B.CURRENCY_CODE%TYPE;
768: lv_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
769:
770: CURSOR c_get_contract_header_details(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
771: SELECT chrv.sts_code,

Line 768: lv_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;

764: ln_orig_system_id1 OKC_K_HEADERS_B.ORIG_SYSTEM_ID1%TYPE;
765: ld_start_date OKC_K_LINES_B.START_DATE%TYPE;
766: ld_end_date OKC_K_LINES_B.END_DATE%TYPE;
767: lv_currency_code OKC_K_HEADERS_B.CURRENCY_CODE%TYPE;
768: lv_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
769:
770: CURSOR c_get_contract_header_details(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
771: SELECT chrv.sts_code,
772: chrv.end_date,

Line 2492: p_dnz_chr_id IN OKC_K_HEADERS_B.ID%TYPE) IS

2488: -- End of Commnets
2489: PROCEDURE validate_new_ast_num_update(x_return_status OUT NOCOPY VARCHAR2,
2490: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
2491: p_kle_Id IN OKL_TXL_ASSETS_V.KLE_ID%TYPE,
2492: p_dnz_chr_id IN OKC_K_HEADERS_B.ID%TYPE) IS
2493: ln_okl_txl_assets_v NUMBER := 0;
2494: ln_okx_assets_v NUMBER := 0;
2495: ln_okx_asset_lines_v NUMBER := 0;
2496: ln_okl_txd_assets_v NUMBER := 0;

Line 2497: lv_source_code OKC_K_HEADERS_B.ORIG_SYSTEM_SOURCE_CODE%TYPE;

2493: ln_okl_txl_assets_v NUMBER := 0;
2494: ln_okx_assets_v NUMBER := 0;
2495: ln_okx_asset_lines_v NUMBER := 0;
2496: ln_okl_txd_assets_v NUMBER := 0;
2497: lv_source_code OKC_K_HEADERS_B.ORIG_SYSTEM_SOURCE_CODE%TYPE;
2498: lv_asset_source_code OKC_K_LINES_B.ORIG_SYSTEM_SOURCE_CODE%TYPE;
2499: lv_asset_number OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE;
2500: lv_release_asset OKC_RULES_V.RULE_INFORMATION1%TYPE := 'N';
2501: x_msg_count NUMBER;

Line 2552: FROM okc_k_headers_b chr,

2548: AND TAS.TSU_CODE = 'ENTERED'; --);
2549:
2550: CURSOR c_source_code(p_kle_Id OKL_TXL_ASSETS_V.KLE_ID%TYPE) is
2551: SELECT nvl(chr.orig_system_source_code,'x')
2552: FROM okc_k_headers_b chr,
2553: okc_k_lines_b cle
2554: WHERE cle.id = p_kle_Id
2555: AND cle.dnz_chr_id = chr.id;
2556:

Line 2557: CURSOR c_check_release_asset(p_dnz_chr_id OKC_K_HEADERS_B.ID%TYPE) is

2553: okc_k_lines_b cle
2554: WHERE cle.id = p_kle_Id
2555: AND cle.dnz_chr_id = chr.id;
2556:
2557: CURSOR c_check_release_asset(p_dnz_chr_id OKC_K_HEADERS_B.ID%TYPE) is
2558: SELECT RULE_INFORMATION1
2559: FROM OKC_RULES_V
2560: WHERE DNZ_CHR_ID = p_dnz_chr_id
2561: AND RULE_INFORMATION_CATEGORY = 'LARLES';

Line 3414: FROM OKC_K_HEADERS_B chrv

3410: CURSOR c_dnz_chr_id_validate(p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
3411: SELECT 1
3412: --FROM DUAL
3413: --WHERE EXISTS (SELECT 1
3414: FROM OKC_K_HEADERS_B chrv
3415: WHERE chrv.id = p_dnz_chr_id; --);
3416: BEGIN
3417: -- initialize return status
3418: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 3509: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%TYPE;

3505: ln3_dummy NUMBER := p_units;
3506: lv_deal_type OKL_K_HEADERS_V.DEAL_TYPE%TYPE := null;
3507: lv_scs_code OKC_K_HEADERS_V.SCS_CODE%TYPE := null;
3508: --Bug# 4419339
3509: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%TYPE;
3510: CURSOR get_deal_type(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE)
3511: IS
3512: SELECT khr.deal_type,
3513: chr.scs_code,

Line 3517: OKC_K_HEADERS_B chr

3513: chr.scs_code,
3514: --Bug# 4419339
3515: chr.orig_system_source_code
3516: FROM OKL_K_HEADERS_V khr,
3517: OKC_K_HEADERS_B chr
3518: WHERE khr.id = p_dnz_chr_id
3519: AND chr.id = khr.id;
3520: BEGIN
3521: IF (p_chr_id <> OKL_API.G_MISS_NUM OR

Line 4175: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

4171: l_trxv_rec trxv_rec_type;
4172: l_talv_rec talv_rec_type;
4173:
4174: --Added by dpsingh for LE uptake
4175: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
4176: l_legal_entity_id NUMBER;
4177:
4178: BEGIN
4179: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 4710: FROM okc_k_headers_b CHR,

4706: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_ASSET_COST';
4707:
4708: CURSOR l_chk_rbk_csr(p_chr_id IN NUMBER) is
4709: SELECT '!'
4710: FROM okc_k_headers_b CHR,
4711: okl_trx_contracts ktrx
4712: WHERE ktrx.khr_id_new = chr.id
4713: AND ktrx.tsu_code = 'ENTERED'
4714: AND ktrx.rbr_code is NOT NULL

Line 4877: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

4873: FROM OKC_K_LINES_B
4874: WHERE ID = p_kle_id1;
4875:
4876: l_chr_id NUMBER;
4877: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
4878: l_legal_entity_id NUMBER;
4879:
4880: BEGIN
4881: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 12210: FROM OKC_K_HEADERS_B chrb,

12206: --cursor to get pdt_id and k_start date
12207: cursor l_chr_csr (p_chr_id in number) is
12208: SELECT chrb.start_date,
12209: khr.pdt_id
12210: FROM OKC_K_HEADERS_B chrb,
12211: OKL_K_HEADERS khr
12212: WHERE khr.id = chrb.id
12213: AND chrb.id = p_chr_id;
12214:

Line 12641: FROM okc_k_headers_b chrb,

12637: --Bug# 4869443
12638: chrb.orig_system_source_code,
12639: --Bug# 6328924
12640: khr.legal_entity_id
12641: FROM okc_k_headers_b chrb,
12642: okl_k_headers khr
12643: WHERE chrb.id = p_chr_id
12644: AND khr.id = chrb.id;
12645:

Line 12738: from okc_k_headers_b chrb

12734:
12735: --Bug# 3783518 :
12736: CURSOR l_chk_rbk_csr (p_chr_id in NUMBER) is
12737: select 'Y'
12738: from okc_k_headers_b chrb
12739: where nvl(chrb.orig_system_source_code,'XXXX') = 'OKL_REBOOK'
12740: and chrb.id = p_chr_id;
12741:
12742: l_rbk_yn varchar2(1);

Line 13958: okc_k_headers_b chrb

13954: from fa_additions_b fab,
13955: okl_txl_assets_b txlb,
13956: okc_k_lines_b fa_cleb,
13957: okc_line_styles_b fa_lseb,
13958: okc_k_headers_b chrb
13959: where fab.asset_number = txlb.asset_number
13960: and fab.asset_id = p_asset_id
13961: and txlb.kle_id = fa_cleb.id
13962: and fa_cleb.dnz_chr_id = chrb.id

Line 13970: l_k_source okc_k_headers_b.orig_system_source_code%TYPE;

13966: and chrb.id = p_chr_id
13967: and chrb.orig_system_source_code = 'OKL_REBOOK';
13968:
13969: l_rbk_ast_change_yn varchar2(1);
13970: l_k_source okc_k_headers_b.orig_system_source_code%TYPE;
13971:
13972: BEGIN
13973: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
13974: -- Call start_activity to create savepoint, check compatibility

Line 14535: FROM okc_k_headers_b chr,

14531:
14532: --cursor to check if the contract is undergoing on-line rebook
14533: CURSOR l_chk_rbk_csr(p_chr_id IN NUMBER) is
14534: SELECT '!'
14535: FROM okc_k_headers_b chr,
14536: okl_trx_contracts ktrx
14537: WHERE ktrx.khr_id_new = chr.id
14538: AND ktrx.tsu_code = 'ENTERED'
14539: AND ktrx.rbr_code is NOT NULL

Line 15107: ln_chr_id OKC_K_HEADERS_B.ID%TYPE;

15103: n NUMBER := 0;
15104: p NUMBER := 0;
15105:
15106: -- added by rravikir (Estimated property tax)
15107: ln_chr_id OKC_K_HEADERS_B.ID%TYPE;
15108: ln_cle_id OKL_K_LINES_V.ID%TYPE;
15109: -- end
15110: TYPE instance_id_tbl IS TABLE OF NUMBER
15111: INDEX BY BINARY_INTEGER;

Line 15113: CURSOR c_get_scs_code(p_dnz_chr_id OKC_K_HEADERS_B.ID%TYPE)

15109: -- end
15110: TYPE instance_id_tbl IS TABLE OF NUMBER
15111: INDEX BY BINARY_INTEGER;
15112: lt_instance_id_tbl instance_id_tbl;
15113: CURSOR c_get_scs_code(p_dnz_chr_id OKC_K_HEADERS_B.ID%TYPE)
15114: IS
15115: SELECT scs_code,
15116: --Bug# 4419339
15117: orig_system_source_code

Line 15118: FROM OKC_K_HEADERS_B

15114: IS
15115: SELECT scs_code,
15116: --Bug# 4419339
15117: orig_system_source_code
15118: FROM OKC_K_HEADERS_B
15119: WHERE id = p_dnz_chr_id;
15120:
15121:
15122: --Bug# 4419339

Line 15123: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%TYPE;

15119: WHERE id = p_dnz_chr_id;
15120:
15121:
15122: --Bug# 4419339
15123: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%TYPE;
15124:
15125: CURSOR c_ib_sno_asset(p_asset_number OKL_TXL_ASSETS_B.ASSET_NUMBER%TYPE)
15126: IS
15127: SELECT CII.SERIAL_NUMBER IB_SERIAL_NUMBER,

Line 15150: FROM okc_k_headers_b CHR

15146:
15147: --cursor to check if contract has re-lease assets
15148: CURSOR l_chk_rel_ast_csr (p_chr_id IN Number) IS
15149: SELECT 'Y'
15150: FROM okc_k_headers_b CHR
15151: WHERE nvl(chr.orig_system_source_code,'XXXX') <> 'OKL_RELEASE'
15152: and chr.ID = p_chr_id
15153: AND exists (SELECT '1'
15154: FROM OKC_RULES_B rul

Line 16299: FROM okc_k_headers_b CHR,

16295: --Bug# 4631549
16296: chr.orig_system_source_code,
16297: chr.orig_system_id1 orig_chr_id,
16298: chr.start_date
16299: FROM okc_k_headers_b CHR,
16300: okc_rules_b rul
16301: WHERE CHR.ID = p_chr_id
16302: AND rul.dnz_chr_id = CHR.id
16303: AND rul.rule_information_category = 'LARLES'

Line 16308: l_orig_system_source_code OKC_K_HEADERS_B.orig_system_source_code%TYPE;

16304: AND NVL(rule_information1,'N') = 'Y';
16305:
16306: l_chk_rel_ast Varchar2(1) default 'N';
16307: --Bug# 4631549
16308: l_orig_system_source_code OKC_K_HEADERS_B.orig_system_source_code%TYPE;
16309: l_orig_chr_id OKC_K_HEADERS_B.ID%TYPE;
16310: l_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
16311:
16312: l_rel_ast_clev_fin_rec clev_rec_type;

Line 16309: l_orig_chr_id OKC_K_HEADERS_B.ID%TYPE;

16305:
16306: l_chk_rel_ast Varchar2(1) default 'N';
16307: --Bug# 4631549
16308: l_orig_system_source_code OKC_K_HEADERS_B.orig_system_source_code%TYPE;
16309: l_orig_chr_id OKC_K_HEADERS_B.ID%TYPE;
16310: l_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
16311:
16312: l_rel_ast_clev_fin_rec clev_rec_type;
16313: l_rel_ast_klev_fin_rec klev_rec_type;

Line 16310: l_start_date OKC_K_HEADERS_B.START_DATE%TYPE;

16306: l_chk_rel_ast Varchar2(1) default 'N';
16307: --Bug# 4631549
16308: l_orig_system_source_code OKC_K_HEADERS_B.orig_system_source_code%TYPE;
16309: l_orig_chr_id OKC_K_HEADERS_B.ID%TYPE;
16310: l_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
16311:
16312: l_rel_ast_clev_fin_rec clev_rec_type;
16313: l_rel_ast_klev_fin_rec klev_rec_type;
16314: l_rel_ast_clev_model_rec clev_rec_type;

Line 16342: FROM okc_k_headers_b CHR,

16338: --Bug# 4899328
16339: --cursor to check if the contract is undergoing on-line rebook
16340: cursor l_chk_rbk_csr(p_chr_id IN NUMBER) is
16341: SELECT '!'
16342: FROM okc_k_headers_b CHR,
16343: okl_trx_contracts ktrx
16344: WHERE ktrx.khr_id_new = chr.id
16345: AND ktrx.tsu_code = 'ENTERED'
16346: AND ktrx.rbr_code is NOT NULL

Line 17996: FROM okc_k_headers_b chr,

17992:
17993: --cursor to check if the contract is undergoing on-line rebook
17994: cursor l_chk_rbk_csr(p_chr_id IN NUMBER) is
17995: SELECT '!'
17996: FROM okc_k_headers_b chr,
17997: okl_trx_contracts ktrx
17998: WHERE ktrx.khr_id_new = chr.id
17999: AND ktrx.tsu_code = 'ENTERED'
18000: AND ktrx.rbr_code is NOT NULL

Line 19016: FROM okc_k_headers_b chr,

19012:
19013: --cursor to check if the contract is undergoing on-line rebook
19014: cursor l_chk_rbk_csr(p_chr_id IN NUMBER) is
19015: SELECT '!'
19016: FROM okc_k_headers_b chr,
19017: okl_trx_contracts ktrx
19018: WHERE ktrx.khr_id_new = chr.id
19019: AND ktrx.tsu_code = 'ENTERED'
19020: AND ktrx.rbr_code is NOT NULL

Line 19897: FROM okc_k_headers_b chr,

19893:
19894: --cursor to check if the contract is undergoing on-line rebook
19895: cursor l_chk_rbk_csr(p_chr_id IN NUMBER) is
19896: SELECT '!'
19897: FROM okc_k_headers_b chr,
19898: okl_trx_contracts ktrx
19899: WHERE ktrx.khr_id_new = chr.id
19900: AND ktrx.tsu_code = 'ENTERED'
19901: AND ktrx.rbr_code is NOT NULL