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_STREAM_PVT dependencies on OKC_RULES_B

Line 2669: okc_rules_b rul1,

2665: lse.lty_code lty_code,
2666: kle.capital_amount capital_amount,
2667: kle.residual_value residual_value
2668: FROM okc_rule_groups_b rgp,
2669: okc_rules_b rul1,
2670: okc_rules_b rul2,
2671: okc_k_lines_b cle,
2672: okl_k_lines kle,
2673: okc_line_styles_b lse

Line 2670: okc_rules_b rul2,

2666: kle.capital_amount capital_amount,
2667: kle.residual_value residual_value
2668: FROM okc_rule_groups_b rgp,
2669: okc_rules_b rul1,
2670: okc_rules_b rul2,
2671: okc_k_lines_b cle,
2672: okl_k_lines kle,
2673: okc_line_styles_b lse
2674: WHERE rul2.dnz_chr_id = p_chr_id

Line 5060: okc_rules_b crl,

5056: IS
5057: SELECT distinct crg.cle_id line_id,
5058: (NVL(crl.rule_information5,-1)) structure
5059: FROM okc_rule_groups_b crg,
5060: okc_rules_b crl,
5061: okc_rules_b crl1
5062: WHERE crl.rgp_id = crg.id
5063: AND crg.rgd_code = 'LALEVL'
5064: AND crl.rule_information_category = 'LASLL'

Line 5061: okc_rules_b crl1

5057: SELECT distinct crg.cle_id line_id,
5058: (NVL(crl.rule_information5,-1)) structure
5059: FROM okc_rule_groups_b crg,
5060: okc_rules_b crl,
5061: okc_rules_b crl1
5062: WHERE crl.rgp_id = crg.id
5063: AND crg.rgd_code = 'LALEVL'
5064: AND crl.rule_information_category = 'LASLL'
5065: AND crl1.rule_information_category = 'LASLH'

Line 5087: okc_rules_b crl,

5083: crl.RULE_INFORMATION8 STUB_AMOUNT,
5084: TUOM.ID1 FREQUENCY,
5085: null END_DATE
5086: FROM okc_rule_groups_b crg,
5087: okc_rules_b crl,
5088: okc_rules_b crl1,
5089: okl_time_units_v tuom
5090: WHERE crl.rgp_id = crg.id
5091: AND crg.rgd_code = 'LALEVL'

Line 5088: okc_rules_b crl1,

5084: TUOM.ID1 FREQUENCY,
5085: null END_DATE
5086: FROM okc_rule_groups_b crg,
5087: okc_rules_b crl,
5088: okc_rules_b crl1,
5089: okl_time_units_v tuom
5090: WHERE crl.rgp_id = crg.id
5091: AND crg.rgd_code = 'LALEVL'
5092: AND crl.rule_information_category = 'LASLL'

Line 7153: okc_rules_b slh,

7149: IS
7150: SELECT sll.id sll_id,
7151: slh.id slh_id
7152: FROM okc_rule_groups_b rgp,
7153: okc_rules_b slh,
7154: okc_rules_b sll
7155: WHERE rgp.dnz_chr_id = p_chr_id
7156: AND rgp.rgd_code = 'LALEVL'
7157: AND rgp.cle_id = p_cle_id

Line 7154: okc_rules_b sll

7150: SELECT sll.id sll_id,
7151: slh.id slh_id
7152: FROM okc_rule_groups_b rgp,
7153: okc_rules_b slh,
7154: okc_rules_b sll
7155: WHERE rgp.dnz_chr_id = p_chr_id
7156: AND rgp.rgd_code = 'LALEVL'
7157: AND rgp.cle_id = p_cle_id
7158: AND rgp.id = slh.rgp_id

Line 8638: FROM okc_rules_b

8634: x NUMBER := 0;
8635:
8636: CURSOR c_deposit_date( chrId NUMBER) IS
8637: SELECT FND_DATE.canonical_to_date(rule_information5) date_returned
8638: FROM okc_rules_b
8639: WHERE dnz_chr_id = chrId
8640: AND rule_information_category = 'LASDEP';
8641:
8642: l_c_deposit_date c_deposit_date%ROWTYPE;

Line 9480: okc_rules_b crl

9476: styt.name strm_name
9477: FROM okl_strm_type_tl styt,
9478: okc_k_items cim,
9479: okc_rule_groups_b crg,
9480: okc_rules_b crl
9481: WHERE crl.rgp_id = crg.id
9482: AND crg.RGD_CODE = 'LAFEXP'
9483: AND crl.RULE_INFORMATION_CATEGORY = 'LAFEXP'
9484: AND crg.dnz_chr_id = p_chr_d

Line 9543: rlcat okc_rules_b.rule_information_category%TYPE,

9539: --End of modification for Bug#3320656 BAKUCHIB Modified
9540: -- get the self referencing Line based rule information
9541: CURSOR l_rl_income_csr(rlgpId NUMBER,
9542: rgcode okc_rule_groups_b.rgd_code%TYPE,
9543: rlcat okc_rules_b.rule_information_category%TYPE,
9544: chrId NUMBER,
9545: cleId NUMBER )
9546: IS
9547: --srsreeni Bug5890437 start

Line 9553: okc_rules_b crl

9549: SELECT SUM(TO_NUMBER(NVL(crl.rule_information3,1))) level_cnt
9550: -- End of modification for Bug#3322910 BAKUCHIB Modified
9551: --srsreeni Bug5890437 end
9552: FROM okc_rule_groups_b crg,
9553: okc_rules_b crl
9554: WHERE crl.rgp_id = crg.id
9555: AND crl.object2_id1 = rlgpId
9556: AND crg.rgd_code = rgcode
9557: AND crl.rule_information_category = rlcat

Line 11911: OKC_RULES_B crl

11907:
11908: Cursor l_struct_csr( chrId NUMBER ) is
11909: select distinct(nvl(crl.RULE_INFORMATION5,-1)) structure
11910: from OKC_RULE_GROUPS_B crg,
11911: OKC_RULES_B crl
11912: where crl.rgp_id = crg.id
11913: and crg.RGD_CODE = 'LALEVL'
11914: and crl.RULE_INFORMATION_CATEGORY = 'LASLL'
11915: and crg.dnz_chr_id = chrId;

Line 13165: OKC_RULES_B crl

13161:
13162: Cursor l_struct_csr( chrId NUMBER ) is
13163: select distinct(nvl(crl.RULE_INFORMATION5,-1)) structure
13164: from OKC_RULE_GROUPS_B crg,
13165: OKC_RULES_B crl
13166: where crl.rgp_id = crg.id
13167: and crg.RGD_CODE = 'LALEVL'
13168: and crl.RULE_INFORMATION_CATEGORY = 'LASLL'
13169: and crg.dnz_chr_id = chrId;

Line 13239: rlcat okc_rules_b.rule_information_category%TYPE,

13235:
13236: --This Cursor fetches the Principal Paydown lines existing per asset line
13237: --on the contract
13238: CURSOR get_prev_ppd_csr(rgcode okc_rule_groups_b.rgd_code%TYPE,
13239: rlcat okc_rules_b.rule_information_category%TYPE,
13240: chrId NUMBER,
13241: cleId NUMBER )
13242: IS
13243: SELECT crl.id slh_id,

Line 13255: okc_rules_b crl,

13251: crl.rule_information8,
13252: crl.rule_information13,
13253: crl.rule_information10
13254: FROM okc_rule_groups_b crg,
13255: okc_rules_b crl,
13256: okl_strm_type_v sty
13257: WHERE crl.rgp_id = crg.id
13258: AND crg.rgd_code = rgcode
13259: AND crl.rule_information_category = rlcat

Line 15240: OKC_RULES_B crl

15236:
15237: Cursor l_struct_csr( chrId NUMBER ) is
15238: select distinct(nvl(crl.RULE_INFORMATION5,-1)) structure
15239: from OKC_RULE_GROUPS_B crg,
15240: OKC_RULES_B crl
15241: where crl.rgp_id = crg.id
15242: and crg.RGD_CODE = 'LALEVL'
15243: and crl.RULE_INFORMATION_CATEGORY = 'LASLL'
15244: and crg.dnz_chr_id = chrId;

Line 15313: rlcat okc_rules_b.rule_information_category%TYPE,

15309:
15310: --This Cursor fetches the Principal Paydown lines existing per asset line
15311: --on the contract
15312: CURSOR get_prev_ppd_csr(rgcode okc_rule_groups_b.rgd_code%TYPE,
15313: rlcat okc_rules_b.rule_information_category%TYPE,
15314: chrId NUMBER,
15315: cleId NUMBER )
15316: IS
15317: SELECT crl.id slh_id,

Line 15329: okc_rules_b crl,

15325: crl.rule_information8,
15326: crl.rule_information13,
15327: crl.rule_information10
15328: FROM okc_rule_groups_b crg,
15329: okc_rules_b crl,
15330: okl_strm_type_v sty
15331: WHERE crl.rgp_id = crg.id
15332: AND crg.rgd_code = rgcode
15333: AND crl.rule_information_category = rlcat

Line 17199: okc_rules_b crl,

17195: CURSOR is_ppd_available_csr(chrId NUMBER)
17196: IS
17197: SELECT count(crl.id)
17198: FROM okc_rule_groups_b crg,
17199: okc_rules_b crl,
17200: okl_strm_type_v sty
17201: WHERE crl.rgp_id = crg.id
17202: AND crg.rgd_code = 'LALEVL'
17203: AND crl.rule_information_category = 'LASLH'

Line 17305: okc_rules_b crl,

17301: strmPurpose VARCHAR2)
17302: IS
17303: SELECT count(crl.id)
17304: FROM okc_rule_groups_b crg,
17305: okc_rules_b crl,
17306: okl_strm_type_v sty
17307: WHERE crl.rgp_id = crg.id
17308: AND crg.rgd_code = 'LALEVL'
17309: AND crl.rule_information_category = 'LASLH'

Line 17500: l_lease_tax_owner okc_rules_b.rule_information1%TYPE := NULL;

17496: l_capint OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
17497: l_discount OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
17498: l_corp_dep_cost OKL_TXL_ASSETS_B.DEPRECIATION_COST%TYPE := 0;
17499: l_tax_dep_cost OKL_TXD_ASSETS_B.COST%TYPE := 0;
17500: l_lease_tax_owner okc_rules_b.rule_information1%TYPE := NULL;
17501: lx_no_data_found BOOLEAN;
17502: -- l_sty_id NUMBER;
17503: l_sty_id strm_rec_type;
17504: l_down_payment_sty_id strm_rec_type;

Line 17559: rlcat okc_rules_b.rule_information_category%TYPE,

17555: AND chr.id = chrId
17556: AND khr.pdt_id = pdt.id(+);
17557: -- get the Lease Header rule information
17558: CURSOR l_hdrrl_csr_lease(rgcode okc_rule_groups_b.rgd_code%TYPE,
17559: rlcat okc_rules_b.rule_information_category%TYPE,
17560: chrId NUMBER)
17561: IS
17562: SELECT crl.object1_id1,
17563: crl.rule_information1,

Line 17573: okc_rules_b crl

17569: crl.rule_information10,
17570: crl.rule_information13,
17571: crl.rule_information11
17572: FROM okc_rule_groups_b crg,
17573: okc_rules_b crl
17574: WHERE crl.rgp_id = crg.id
17575: AND crg.rgd_code = rgcode
17576: AND crl.rule_information_category = rlcat
17577: AND crg.dnz_chr_id = chrId;

Line 17681: rlcat okc_rules_b.rule_information_category%TYPE,

17677: AND books.book_type_code = Book
17678: AND trns.sgn_code = 'STMP';
17679: -- get the lease Line rule information
17680: CURSOR l_slh_csr_lease(rgcode okc_rule_groups_b.rgd_code%TYPE,
17681: rlcat okc_rules_b.rule_information_category%TYPE,
17682: chrId NUMBER,
17683: cleId NUMBER )
17684: IS
17685: SELECT crl.id slh_id,

Line 17697: okc_rules_b crl

17693: crl.rule_information8,
17694: crl.rule_information13,
17695: crl.rule_information10
17696: FROM okc_rule_groups_b crg,
17697: okc_rules_b crl
17698: WHERE crl.rgp_id = crg.id
17699: AND crg.rgd_code = rgcode
17700: AND crl.rule_information_category = rlcat
17701: AND crg.dnz_chr_id = chrId

Line 17721: rlcat okc_rules_b.rule_information_category%TYPE,

17717: AND stm.id = styid;
17718: -- get the self referencing Line based rule information
17719: CURSOR l_sll_csr_lease(rlgpId NUMBER,
17720: rgcode okc_rule_groups_b.rgd_code%TYPE,
17721: rlcat okc_rules_b.rule_information_category%TYPE,
17722: chrId NUMBER,
17723: cleId NUMBER )
17724: IS
17725: SELECT crl.object1_id1,

Line 17736: okc_rules_b crl

17732: crl.rule_information8,
17733: crl.rule_information13,
17734: crl.rule_information10
17735: FROM okc_rule_groups_b crg,
17736: okc_rules_b crl
17737: WHERE crl.rgp_id = crg.id
17738: AND crl.object2_id1 = rlgpId
17739: AND crg.rgd_code = rgcode
17740: AND crl.rule_information_category = rlcat

Line 19380: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,

19376: l_transaction_type VARCHAR2(256):= 'Miscellaneous';--'Generate Yields';
19377: l_request_id NUMBER;
19378:
19379: cursor l_nullrl_csr( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
19380: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
19381: chrId NUMBER,
19382: cleId NUMBER ) IS
19383: select crl.id
19384: from OKC_RULE_GROUPS_B crg,

Line 19385: OKC_RULES_B crl

19381: chrId NUMBER,
19382: cleId NUMBER ) IS
19383: select crl.id
19384: from OKC_RULE_GROUPS_B crg,
19385: OKC_RULES_B crl
19386: where crl.rgp_id = crg.id
19387: and crg.RGD_CODE = rgcode
19388: and crl.RULE_INFORMATION_CATEGORY = rlcat
19389: and crl.RULE_INFORMATION2 is null

Line 19627: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,

19623: l_lines_rec l_line_rec_csr%ROWTYPE;
19624: l_transaction_type VARCHAR2(256):= 'Miscellaneous';--'Generate Yields';
19625:
19626: cursor l_nullrl_csr( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
19627: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
19628: chrId NUMBER ) IS
19629: select crl.id
19630: from OKC_RULE_GROUPS_B crg,
19631: OKC_RULES_B crl

Line 19631: OKC_RULES_B crl

19627: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
19628: chrId NUMBER ) IS
19629: select crl.id
19630: from OKC_RULE_GROUPS_B crg,
19631: OKC_RULES_B crl
19632: where crl.rgp_id = crg.id
19633: and crg.RGD_CODE = rgcode
19634: and crl.RULE_INFORMATION_CATEGORY = rlcat
19635: and nvl(crl.RULE_INFORMATION1, 'XXX' ) = 'XXX'

Line 20035: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,

20031: x_stmv_rec Okl_Streams_pub.stmv_rec_type;
20032: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
20033:
20034: cursor l_rl_csr( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
20035: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
20036: chrId NUMBER,
20037: cleId NUMBER ) IS
20038: select crl.object1_id1,
20039: crl.RULE_INFORMATION1,

Line 20046: OKC_RULES_B crl

20042: crl.RULE_INFORMATION5,
20043: crl.RULE_INFORMATION6,
20044: crl.RULE_INFORMATION10
20045: from OKC_RULE_GROUPS_B crg,
20046: OKC_RULES_B crl
20047: where crl.rgp_id = crg.id
20048: and crg.RGD_CODE = rgcode
20049: and crl.RULE_INFORMATION_CATEGORY = rlcat
20050: and crg.dnz_chr_id = chrId

Line 20065: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,

20061: k NUMBER;
20062: temp NUMBER;
20063:
20064: cursor l_nullrl_csr( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
20065: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
20066: chrId NUMBER,
20067: cleId NUMBER ) IS
20068: select crl.id
20069: from OKC_RULE_GROUPS_B crg,

Line 20070: OKC_RULES_B crl

20066: chrId NUMBER,
20067: cleId NUMBER ) IS
20068: select crl.id
20069: from OKC_RULE_GROUPS_B crg,
20070: OKC_RULES_B crl
20071: where crl.rgp_id = crg.id
20072: and crg.RGD_CODE = rgcode
20073: and crl.RULE_INFORMATION_CATEGORY = rlcat
20074: and nvl(crl.RULE_INFORMATION1, 'XXX' ) = 'XXX'

Line 20786: G_RUL_SLH_CODE okc_rules_b.rule_information_category%TYPE := 'LASLH';

20782: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_PAYMENTS';
20783: G_APP_NAME VARCHAR2(30) := 'OKL';
20784: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
20785: G_RGD_CODE okc_rule_groups_b.rgd_code%TYPE := 'LALEVL';
20786: G_RUL_SLH_CODE okc_rules_b.rule_information_category%TYPE := 'LASLH';
20787: G_RUL_SLL_CODE okc_rules_b.rule_information_category%TYPE := 'LASLL';
20788: G_FEE_TYPE okl_k_lines.fee_type%TYPE := 'PASSTHROUGH';
20789: -- Messages
20790: G_PAYMENT_OVERLAP_ERROR VARCHAR2(200) := 'OKL_PAYMENT_OVERLAP_ERROR';

Line 20787: G_RUL_SLL_CODE okc_rules_b.rule_information_category%TYPE := 'LASLL';

20783: G_APP_NAME VARCHAR2(30) := 'OKL';
20784: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
20785: G_RGD_CODE okc_rule_groups_b.rgd_code%TYPE := 'LALEVL';
20786: G_RUL_SLH_CODE okc_rules_b.rule_information_category%TYPE := 'LASLH';
20787: G_RUL_SLL_CODE okc_rules_b.rule_information_category%TYPE := 'LASLL';
20788: G_FEE_TYPE okl_k_lines.fee_type%TYPE := 'PASSTHROUGH';
20789: -- Messages
20790: G_PAYMENT_OVERLAP_ERROR VARCHAR2(200) := 'OKL_PAYMENT_OVERLAP_ERROR';
20791: G_PAYMENT_GAP_ERROR VARCHAR2(200) := 'OKL_PAYMENT_GAP_ERROR';

Line 20822: FROM okc_rules_b slh,

20818: CURSOR c_get_pay_psth_csr(p_khr_id okl_k_headers.id%TYPE,
20819: p_kle_id okl_k_headers.id%TYPE)
20820: IS
20821: SELECT COUNT(*)
20822: FROM okc_rules_b slh,
20823: okc_rule_groups_b rgp,
20824: okl_k_lines kle
20825: WHERE rgp.dnz_chr_id = p_khr_id
20826: AND kle.id = p_kle_id

Line 20850: okc_rules_b rul

20846: p_cle_id okl_k_lines.id%TYPE)
20847: IS
20848: SELECT rul.id slh_id
20849: FROM okc_rule_groups_b rgp,
20850: okc_rules_b rul
20851: WHERE rul.rgp_id = rgp.id
20852: AND rgp.rgd_code = G_RGD_CODE
20853: AND rul.rule_information_category = G_RUL_SLH_CODE
20854: AND rgp.dnz_chr_id = p_khr_id

Line 20860: p_slh_id okc_rules_b.id%TYPE)

20856:
20857: -- Get all the SLL payment lines for Each Khr_id,SLH id and Line Id
20858: CURSOR c_get_sll_lines_csr(p_khr_id okl_k_headers.id%TYPE,
20859: p_cle_id okl_k_lines.id%TYPE,
20860: p_slh_id okc_rules_b.id%TYPE)
20861: IS
20862: SELECT FND_DATE.canonical_to_date(sll.rule_information2) start_date,
20863: /* DECODE(SLL.rule_information7,
20864: NULL,(ADD_MONTHS(FND_DATE.canonical_to_date(sll.rule_information2),to_number(SLL.rule_information3)*DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12))-1),

Line 20882: FROM okc_rules_b sll,

20878: -- End of BAKUCHIB modification bug#3121708
20879: sll.rule_information13 rate,
20880: nvl(sll.rule_information10,'Y') arrears_yn,
20881: sll.rule_information5 structure
20882: FROM okc_rules_b sll,
20883: okc_rules_b slh,
20884: okc_rule_groups_b rgp
20885: WHERE rgp.dnz_chr_id = p_khr_id
20886: AND rgp.cle_id = p_cle_id

Line 20883: okc_rules_b slh,

20879: sll.rule_information13 rate,
20880: nvl(sll.rule_information10,'Y') arrears_yn,
20881: sll.rule_information5 structure
20882: FROM okc_rules_b sll,
20883: okc_rules_b slh,
20884: okc_rule_groups_b rgp
20885: WHERE rgp.dnz_chr_id = p_khr_id
20886: AND rgp.cle_id = p_cle_id
20887: AND slh.id = p_slh_id

Line 20905: start_date okc_rules_b.last_update_date%TYPE := okl_api.G_MISS_DATE,

20901: WHERE EXISTS (SELECT 1
20902: FROM okc_k_headers_b
20903: WHERE id = p_khr_id);
20904: TYPE sll_date_rec_type IS RECORD (
20905: start_date okc_rules_b.last_update_date%TYPE := okl_api.G_MISS_DATE,
20906: end_date okc_rules_b.last_update_date%TYPE := okl_api.G_MISS_DATE);
20907: TYPE sll_date_tbl_type IS TABLE OF sll_date_rec_type
20908: INDEX BY BINARY_INTEGER;
20909: lt_sll_date_tbl_type sll_date_tbl_type;

Line 20906: end_date okc_rules_b.last_update_date%TYPE := okl_api.G_MISS_DATE);

20902: FROM okc_k_headers_b
20903: WHERE id = p_khr_id);
20904: TYPE sll_date_rec_type IS RECORD (
20905: start_date okc_rules_b.last_update_date%TYPE := okl_api.G_MISS_DATE,
20906: end_date okc_rules_b.last_update_date%TYPE := okl_api.G_MISS_DATE);
20907: TYPE sll_date_tbl_type IS TABLE OF sll_date_rec_type
20908: INDEX BY BINARY_INTEGER;
20909: lt_sll_date_tbl_type sll_date_tbl_type;
20910: l_paym_tbl OKL_STREAM_GENERATOR_PVT.payment_tbl_type := p_paym_tbl;

Line 21408: okc_rules_b rul_rv,

21404: FROM okc_k_headers_b chr_rv,
21405: okc_line_styles_b lse_rv,
21406: okl_k_lines kle_rv,
21407: okc_k_lines_b cle_rv,
21408: okc_rules_b rul_rv,
21409: okc_rule_groups_b rgp_rv,
21410: okc_line_styles_b lse_so,
21411: okc_k_lines_b cle_so,
21412: okc_rules_b rul_so,

Line 21412: okc_rules_b rul_so,

21408: okc_rules_b rul_rv,
21409: okc_rule_groups_b rgp_rv,
21410: okc_line_styles_b lse_so,
21411: okc_k_lines_b cle_so,
21412: okc_rules_b rul_so,
21413: okc_rule_groups_b rgp_so
21414: WHERE rgp_so.cle_id = p_kle_id
21415: AND rgp_so.dnz_chr_id = p_khr_id
21416: AND rgp_so.rgd_code = 'SOPYSC'

Line 21531: okc_rules_b rul_rv,

21527: FROM okc_k_headers_b chr_rv,
21528: okc_line_styles_b lse_rv,
21529: okl_k_lines kle_rv,
21530: okc_k_lines_b cle_rv,
21531: okc_rules_b rul_rv,
21532: okc_rule_groups_b rgp_rv,
21533: okc_line_styles_b lse_so,
21534: okc_k_lines_b cle_so,
21535: okc_rules_b rul_so,

Line 21535: okc_rules_b rul_so,

21531: okc_rules_b rul_rv,
21532: okc_rule_groups_b rgp_rv,
21533: okc_line_styles_b lse_so,
21534: okc_k_lines_b cle_so,
21535: okc_rules_b rul_so,
21536: okc_rule_groups_b rgp_so
21537: WHERE rgp_so.cle_id = p_kle_id
21538: AND rgp_so.dnz_chr_id = p_khr_id
21539: AND rgp_so.rgd_code = 'SOPYSC'

Line 21870: l_lease_tax_owner okc_rules_b.rule_information1%TYPE := NULL;

21866: l_capint OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
21867: l_discount OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
21868: l_corp_dep_cost OKL_TXL_ASSETS_B.DEPRECIATION_COST%TYPE := 0;
21869: l_tax_dep_cost OKL_TXD_ASSETS_B.COST%TYPE := 0;
21870: l_lease_tax_owner okc_rules_b.rule_information1%TYPE := NULL;
21871: -- get the Contract Header info
21872: CURSOR l_hdr_csr(chrId NUMBER)
21873: IS
21874: SELECT chr.orig_system_source_code,

Line 21893: rlcat okc_rules_b.rule_information_category%TYPE,

21889: AND chr.id = chrId
21890: AND khr.pdt_id = pdt.id(+);
21891: -- get the Header rule information
21892: CURSOR l_hdrrl_csr(rgcode okc_rule_groups_b.rgd_code%TYPE,
21893: rlcat okc_rules_b.rule_information_category%TYPE,
21894: chrId NUMBER)
21895: IS
21896: SELECT crl.object1_id1,
21897: crl.rule_information1,

Line 21907: okc_rules_b crl

21903: crl.rule_information10,
21904: crl.rule_information13,
21905: crl.rule_information11
21906: FROM okc_rule_groups_b crg,
21907: okc_rules_b crl
21908: WHERE crl.rgp_id = crg.id
21909: AND crg.rgd_code = rgcode
21910: AND crl.rule_information_category = rlcat
21911: AND crg.dnz_chr_id = chrId;

Line 22073: rlcat okc_rules_b.rule_information_category%TYPE,

22069: AND tl.language = 'US'
22070: AND stm.id = styid;
22071: -- get the LASLH self referencing Line based rule information
22072: CURSOR l_rl_csr1(rgcode okc_rule_groups_b.rgd_code%TYPE,
22073: rlcat okc_rules_b.rule_information_category%TYPE,
22074: chrId NUMBER,
22075: cleId NUMBER )
22076: IS
22077: SELECT crl.id slh_id,

Line 22089: okc_rules_b crl

22085: crl.rule_information8,
22086: crl.rule_information13,
22087: crl.rule_information10
22088: FROM okc_rule_groups_b crg,
22089: okc_rules_b crl
22090: WHERE crl.rgp_id = crg.id
22091: AND crg.rgd_code = rgcode
22092: AND crl.rule_information_category = rlcat
22093: AND crg.dnz_chr_id = chrId

Line 22099: rlcat okc_rules_b.rule_information_category%TYPE,

22095: ORDER BY crl.rule_information1;
22096: -- get the LASLL self referencing Line based rule information
22097: CURSOR l_rl_csr(rlgpId NUMBER,
22098: rgcode okc_rule_groups_b.rgd_code%TYPE,
22099: rlcat okc_rules_b.rule_information_category%TYPE,
22100: chrId NUMBER,
22101: cleId NUMBER )
22102: IS
22103: SELECT crl.object1_id1,

Line 22114: okc_rules_b crl

22110: crl.rule_information8,
22111: crl.rule_information13,
22112: crl.rule_information10
22113: FROM okc_rule_groups_b crg,
22114: okc_rules_b crl
22115: WHERE crl.rgp_id = crg.id
22116: AND crl.object2_id1 = rlgpId
22117: AND crg.rgd_code = rgcode
22118: AND crl.rule_information_category = rlcat

Line 22127: okc_rules_b crl

22123: CURSOR l_struct_csr(chrId NUMBER)
22124: IS
22125: SELECT DISTINCT(nvl(crl.rule_information5,-1)) structure
22126: FROM okc_rule_groups_b crg,
22127: okc_rules_b crl
22128: WHERE crl.rgp_id = crg.id
22129: AND crg.rgd_code = 'LALEVL'
22130: AND crl.rule_information_category = 'LASLL'
22131: AND crg.dnz_chr_id = chrId;

Line 22185: FROM okc_rules_b sll,

22181: MAX(DECODE(SLL.rule_information7,
22182: NULL,(ADD_MONTHS(FND_DATE.canonical_to_date(sll.rule_information2),to_number(SLL.rule_information3)*DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12))-1),
22183: TO_NUMBER(SLL.rule_information7),FND_DATE.canonical_to_date(sll.rule_information2)+SLL.rule_information7-1,
22184: (ADD_MONTHS(FND_DATE.canonical_to_date(sll.rule_information2),to_number(SLL.rule_information3)*DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12))-1))) pay_end_date
22185: FROM okc_rules_b sll,
22186: okc_rules_b slh,
22187: okc_rule_groups_b rgp,
22188: okc_k_headers_b chrv
22189: WHERE rgp.dnz_chr_id = p_chr_id

Line 22186: okc_rules_b slh,

22182: NULL,(ADD_MONTHS(FND_DATE.canonical_to_date(sll.rule_information2),to_number(SLL.rule_information3)*DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12))-1),
22183: TO_NUMBER(SLL.rule_information7),FND_DATE.canonical_to_date(sll.rule_information2)+SLL.rule_information7-1,
22184: (ADD_MONTHS(FND_DATE.canonical_to_date(sll.rule_information2),to_number(SLL.rule_information3)*DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12))-1))) pay_end_date
22185: FROM okc_rules_b sll,
22186: okc_rules_b slh,
22187: okc_rule_groups_b rgp,
22188: okc_k_headers_b chrv
22189: WHERE rgp.dnz_chr_id = p_chr_id
22190: AND rgp.cle_id = p_cle_id