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 3085: okc_rules_b rul1,

3081: lse.lty_code lty_code,
3082: kle.capital_amount capital_amount,
3083: kle.residual_value residual_value
3084: FROM okc_rule_groups_b rgp,
3085: okc_rules_b rul1,
3086: okc_rules_b rul2,
3087: okc_k_lines_b cle,
3088: okl_k_lines kle,
3089: okc_line_styles_b lse

Line 3086: okc_rules_b rul2,

3082: kle.capital_amount capital_amount,
3083: kle.residual_value residual_value
3084: FROM okc_rule_groups_b rgp,
3085: okc_rules_b rul1,
3086: okc_rules_b rul2,
3087: okc_k_lines_b cle,
3088: okl_k_lines kle,
3089: okc_line_styles_b lse
3090: WHERE rul2.dnz_chr_id = p_chr_id

Line 3238: okc_rules_b rul

3234: --Cursor to get the fee payment frequency
3235: CURSOR c_feepayment_freq(khrId NUMBER, cleId NUMBER) IS
3236: SELECT rul.object1_id1 frequency
3237: FROM okc_rule_groups_b rgp,
3238: okc_rules_b rul
3239: WHERE rgp.dnz_chr_id = khrId
3240: AND rgp.cle_id = cleId
3241: AND rgp.RGD_CODE = 'LALEVL'
3242: AND rgp.id = rul.rgp_id

Line 3848: ,okc_rules_b rul

3844: SELECT rul.object1_id1 payment_frequency
3845: ,MIN(pmnt.start_date) payment_period_start_date
3846: ,MAX(pmnt.end_date) payment_period_end_date
3847: FROM okc_rule_groups_b rgp
3848: ,okc_rules_b rul
3849: ,OKL_OR_PAYMENT_DETAILS_UV pmnt
3850: WHERE rgp.dnz_chr_id = khrId
3851: AND rgp.cle_id = cleId
3852: AND rgp.RGD_CODE = 'LALEVL'

Line 4176: ,okc_rules_b rul

4172: SELECT rul.object1_id1 payment_frequency
4173: ,MIN(pmnt.start_date) payment_period_start_date
4174: ,MAX(pmnt.end_date) payment_period_end_date
4175: FROM okc_rule_groups_b rgp
4176: ,okc_rules_b rul
4177: ,OKL_OR_PAYMENT_DETAILS_UV pmnt
4178: WHERE rgp.dnz_chr_id = khrId
4179: AND rgp.cle_id = cleId
4180: AND rgp.RGD_CODE = 'LALEVL'

Line 6161: okc_rules_b crl,

6157: (NVL(crl.rule_information5,-1)) structure
6158: ,cle.sts_code sts_code
6159: ,date_terminated date_terminated
6160: FROM okc_rule_groups_b crg,
6161: okc_rules_b crl,
6162: okc_rules_b crl1,
6163: -- Bug 7653893 : RGOOTY
6164: okc_k_lines_b cle
6165: WHERE crl.rgp_id = crg.id

Line 6162: okc_rules_b crl1,

6158: ,cle.sts_code sts_code
6159: ,date_terminated date_terminated
6160: FROM okc_rule_groups_b crg,
6161: okc_rules_b crl,
6162: okc_rules_b crl1,
6163: -- Bug 7653893 : RGOOTY
6164: okc_k_lines_b cle
6165: WHERE crl.rgp_id = crg.id
6166: AND crg.rgd_code = 'LALEVL'

Line 6191: okc_rules_b crl,

6187: crl.RULE_INFORMATION8 STUB_AMOUNT,
6188: TUOM.ID1 FREQUENCY,
6189: null END_DATE
6190: FROM okc_rule_groups_b crg,
6191: okc_rules_b crl,
6192: okc_rules_b crl1,
6193: okl_time_units_v tuom
6194: WHERE crl.rgp_id = crg.id
6195: AND crg.rgd_code = 'LALEVL'

Line 6192: okc_rules_b crl1,

6188: TUOM.ID1 FREQUENCY,
6189: null END_DATE
6190: FROM okc_rule_groups_b crg,
6191: okc_rules_b crl,
6192: okc_rules_b crl1,
6193: okl_time_units_v tuom
6194: WHERE crl.rgp_id = crg.id
6195: AND crg.rgd_code = 'LALEVL'
6196: AND crl.rule_information_category = 'LASLL'

Line 8647: okc_rules_b slh,

8643: IS
8644: SELECT sll.id sll_id,
8645: slh.id slh_id
8646: FROM okc_rule_groups_b rgp,
8647: okc_rules_b slh,
8648: okc_rules_b sll
8649: WHERE rgp.dnz_chr_id = p_chr_id
8650: AND rgp.rgd_code = 'LALEVL'
8651: AND rgp.cle_id = p_cle_id

Line 8648: okc_rules_b sll

8644: SELECT sll.id sll_id,
8645: slh.id slh_id
8646: FROM okc_rule_groups_b rgp,
8647: okc_rules_b slh,
8648: okc_rules_b sll
8649: WHERE rgp.dnz_chr_id = p_chr_id
8650: AND rgp.rgd_code = 'LALEVL'
8651: AND rgp.cle_id = p_cle_id
8652: AND rgp.id = slh.rgp_id

Line 10159: FROM okc_rules_b

10155: x NUMBER := 0;
10156:
10157: CURSOR c_deposit_date( chrId NUMBER) IS
10158: SELECT FND_DATE.canonical_to_date(rule_information5) date_returned
10159: FROM okc_rules_b
10160: WHERE dnz_chr_id = chrId
10161: AND rule_information_category = 'LASDEP';
10162:
10163: l_c_deposit_date c_deposit_date%ROWTYPE;

Line 11066: okc_rules_b crl

11062: styt.name strm_name
11063: FROM okl_strm_type_tl styt,
11064: okc_k_items cim,
11065: okc_rule_groups_b crg,
11066: okc_rules_b crl
11067: WHERE crl.rgp_id = crg.id
11068: AND crg.RGD_CODE = 'LAFEXP'
11069: AND crl.RULE_INFORMATION_CATEGORY = 'LAFEXP'
11070: AND crg.dnz_chr_id = p_chr_d

Line 11131: rlcat okc_rules_b.rule_information_category%TYPE,

11127: --End of modification for Bug#3320656 BAKUCHIB Modified
11128: -- get the self referencing Line based rule information
11129: CURSOR l_rl_income_csr(rlgpId NUMBER,
11130: rgcode okc_rule_groups_b.rgd_code%TYPE,
11131: rlcat okc_rules_b.rule_information_category%TYPE,
11132: chrId NUMBER,
11133: cleId NUMBER )
11134: IS
11135: --srsreeni Bug5890437 start

Line 11141: okc_rules_b crl

11137: SELECT SUM(TO_NUMBER(NVL(crl.rule_information3,1))) level_cnt
11138: -- End of modification for Bug#3322910 BAKUCHIB Modified
11139: --srsreeni Bug5890437 end
11140: FROM okc_rule_groups_b crg,
11141: okc_rules_b crl
11142: WHERE crl.rgp_id = crg.id
11143: AND crl.object2_id1 = rlgpId
11144: AND crg.rgd_code = rgcode
11145: AND crl.rule_information_category = rlcat

Line 11226: okc_rules_b rul

11222: --Cursor to get the fee payment frequency
11223: CURSOR c_feepayment_freq(khrId NUMBER, cleId NUMBER) IS
11224: SELECT rul.object1_id1 frequency
11225: FROM okc_rule_groups_b rgp,
11226: okc_rules_b rul
11227: WHERE rgp.dnz_chr_id = khrId
11228: AND rgp.cle_id = cleId
11229: AND rgp.RGD_CODE = 'LALEVL'
11230: AND rgp.id = rul.rgp_id

Line 13841: OKC_RULES_B crl

13837:
13838: Cursor l_struct_csr( chrId NUMBER ) is
13839: select distinct(nvl(crl.RULE_INFORMATION5,-1)) structure
13840: from OKC_RULE_GROUPS_B crg,
13841: OKC_RULES_B crl
13842: where crl.rgp_id = crg.id
13843: and crg.RGD_CODE = 'LALEVL'
13844: and crl.RULE_INFORMATION_CATEGORY = 'LASLL'
13845: and crg.dnz_chr_id = chrId;

Line 15268: OKC_RULES_B crl

15264:
15265: Cursor l_struct_csr( chrId NUMBER ) is
15266: select distinct(nvl(crl.RULE_INFORMATION5,-1)) structure
15267: from OKC_RULE_GROUPS_B crg,
15268: OKC_RULES_B crl
15269: where crl.rgp_id = crg.id
15270: and crg.RGD_CODE = 'LALEVL'
15271: and crl.RULE_INFORMATION_CATEGORY = 'LASLL'
15272: and crg.dnz_chr_id = chrId;

Line 15342: rlcat okc_rules_b.rule_information_category%TYPE,

15338:
15339: --This Cursor fetches the Principal Paydown lines existing per asset line
15340: --on the contract
15341: CURSOR get_prev_ppd_csr(rgcode okc_rule_groups_b.rgd_code%TYPE,
15342: rlcat okc_rules_b.rule_information_category%TYPE,
15343: chrId NUMBER,
15344: cleId NUMBER )
15345: IS
15346: SELECT crl.id slh_id,

Line 15358: okc_rules_b crl,

15354: crl.rule_information8,
15355: crl.rule_information13,
15356: crl.rule_information10
15357: FROM okc_rule_groups_b crg,
15358: okc_rules_b crl,
15359: okl_strm_type_v sty
15360: WHERE crl.rgp_id = crg.id
15361: AND crg.rgd_code = rgcode
15362: AND crl.rule_information_category = rlcat

Line 17553: OKC_RULES_B crl

17549:
17550: Cursor l_struct_csr( chrId NUMBER ) is
17551: select distinct(nvl(crl.RULE_INFORMATION5,-1)) structure
17552: from OKC_RULE_GROUPS_B crg,
17553: OKC_RULES_B crl
17554: where crl.rgp_id = crg.id
17555: and crg.RGD_CODE = 'LALEVL'
17556: and crl.RULE_INFORMATION_CATEGORY = 'LASLL'
17557: and crg.dnz_chr_id = chrId;

Line 17634: rlcat okc_rules_b.rule_information_category%TYPE,

17630:
17631: --This Cursor fetches the Principal Paydown lines existing per asset line
17632: --on the contract
17633: CURSOR get_prev_ppd_csr(rgcode okc_rule_groups_b.rgd_code%TYPE,
17634: rlcat okc_rules_b.rule_information_category%TYPE,
17635: chrId NUMBER,
17636: cleId NUMBER )
17637: IS
17638: SELECT crl.id slh_id,

Line 17650: okc_rules_b crl,

17646: crl.rule_information8,
17647: crl.rule_information13,
17648: crl.rule_information10
17649: FROM okc_rule_groups_b crg,
17650: okc_rules_b crl,
17651: okl_strm_type_v sty
17652: WHERE crl.rgp_id = crg.id
17653: AND crg.rgd_code = rgcode
17654: AND crl.rule_information_category = rlcat

Line 19804: okc_rules_b crl,

19800: CURSOR is_ppd_available_csr(chrId NUMBER)
19801: IS
19802: SELECT count(crl.id)
19803: FROM okc_rule_groups_b crg,
19804: okc_rules_b crl,
19805: okl_strm_type_v sty
19806: WHERE crl.rgp_id = crg.id
19807: AND crg.rgd_code = 'LALEVL'
19808: AND crl.rule_information_category = 'LASLH'

Line 19911: okc_rules_b crl,

19907: strmPurpose VARCHAR2)
19908: IS
19909: SELECT count(crl.id)
19910: FROM okc_rule_groups_b crg,
19911: okc_rules_b crl,
19912: okl_strm_type_v sty
19913: WHERE crl.rgp_id = crg.id
19914: AND crg.rgd_code = 'LALEVL'
19915: AND crl.rule_information_category = 'LASLH'

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

20105: l_capint OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
20106: l_discount OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
20107: l_corp_dep_cost OKL_TXL_ASSETS_B.DEPRECIATION_COST%TYPE := 0;
20108: l_tax_dep_cost OKL_TXD_ASSETS_B.COST%TYPE := 0;
20109: l_lease_tax_owner okc_rules_b.rule_information1%TYPE := NULL;
20110: lx_no_data_found BOOLEAN;
20111: -- l_sty_id NUMBER;
20112: l_sty_id strm_rec_type;
20113: l_down_payment_sty_id strm_rec_type;

Line 20126: l_adv_arrears okc_rules_b.rule_information10%TYPE;

20122: l_down_payment_amt NUMBER; --Added by bkatraga for bug 15942693
20123:
20124: --Added by bkatraga for bug 14822974
20125: l_arrears_pay_dates_option okl_st_gen_tmpt_sets_all.isg_arrears_pay_dates_option%TYPE;
20126: l_adv_arrears okc_rules_b.rule_information10%TYPE;
20127:
20128: CURSOR l_adv_arrears_csr (p_khr_id in NUMBER, p_cle_id in NUMBER) is
20129: select nvl( sll_rulb.rule_information10,'N') advance_or_arrears
20130: from okc_rules_b sll_rulb,

Line 20130: from okc_rules_b sll_rulb,

20126: l_adv_arrears okc_rules_b.rule_information10%TYPE;
20127:
20128: CURSOR l_adv_arrears_csr (p_khr_id in NUMBER, p_cle_id in NUMBER) is
20129: select nvl( sll_rulb.rule_information10,'N') advance_or_arrears
20130: from okc_rules_b sll_rulb,
20131: okc_rules_b slh_rulb,
20132: okl_strm_type_b styb,
20133: okc_rule_groups_b rgpb
20134: where sll_rulb.rgp_id = rgpb.id

Line 20131: okc_rules_b slh_rulb,

20127:
20128: CURSOR l_adv_arrears_csr (p_khr_id in NUMBER, p_cle_id in NUMBER) is
20129: select nvl( sll_rulb.rule_information10,'N') advance_or_arrears
20130: from okc_rules_b sll_rulb,
20131: okc_rules_b slh_rulb,
20132: okl_strm_type_b styb,
20133: okc_rule_groups_b rgpb
20134: where sll_rulb.rgp_id = rgpb.id
20135: and sll_rulb.rule_information_category = 'LASLL'

Line 20193: rlcat okc_rules_b.rule_information_category%TYPE,

20189: AND chr.id = chrId
20190: AND khr.pdt_id = pdt.id(+);
20191: -- get the Lease Header rule information
20192: CURSOR l_hdrrl_csr_lease(rgcode okc_rule_groups_b.rgd_code%TYPE,
20193: rlcat okc_rules_b.rule_information_category%TYPE,
20194: chrId NUMBER)
20195: IS
20196: SELECT crl.object1_id1,
20197: crl.rule_information1,

Line 20207: okc_rules_b crl

20203: crl.rule_information10,
20204: crl.rule_information13,
20205: crl.rule_information11
20206: FROM okc_rule_groups_b crg,
20207: okc_rules_b crl
20208: WHERE crl.rgp_id = crg.id
20209: AND crg.rgd_code = rgcode
20210: AND crl.rule_information_category = rlcat
20211: AND crg.dnz_chr_id = chrId;

Line 20319: rlcat okc_rules_b.rule_information_category%TYPE,

20315: AND books.book_type_code = Book
20316: AND trns.sgn_code = 'STMP';
20317: -- get the lease Line rule information
20318: CURSOR l_slh_csr_lease(rgcode okc_rule_groups_b.rgd_code%TYPE,
20319: rlcat okc_rules_b.rule_information_category%TYPE,
20320: chrId NUMBER,
20321: cleId NUMBER )
20322: IS
20323: SELECT crl.id slh_id,

Line 20335: okc_rules_b crl

20331: crl.rule_information8,
20332: crl.rule_information13,
20333: crl.rule_information10
20334: FROM okc_rule_groups_b crg,
20335: okc_rules_b crl
20336: WHERE crl.rgp_id = crg.id
20337: AND crg.rgd_code = rgcode
20338: AND crl.rule_information_category = rlcat
20339: AND crg.dnz_chr_id = chrId

Line 20359: rlcat okc_rules_b.rule_information_category%TYPE,

20355: AND stm.id = styid;
20356: -- get the self referencing Line based rule information
20357: CURSOR l_sll_csr_lease(rlgpId NUMBER,
20358: rgcode okc_rule_groups_b.rgd_code%TYPE,
20359: rlcat okc_rules_b.rule_information_category%TYPE,
20360: chrId NUMBER,
20361: cleId NUMBER )
20362: IS
20363: SELECT crl.object1_id1,

Line 20374: okc_rules_b crl

20370: crl.rule_information8,
20371: crl.rule_information13,
20372: crl.rule_information10
20373: FROM okc_rule_groups_b crg,
20374: okc_rules_b crl
20375: WHERE crl.rgp_id = crg.id
20376: AND crl.object2_id1 = rlgpId
20377: AND crg.rgd_code = rgcode
20378: AND crl.rule_information_category = rlcat

Line 22171: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,

22167: l_transaction_type VARCHAR2(256):= 'Miscellaneous';--'Generate Yields';
22168: l_request_id NUMBER;
22169:
22170: cursor l_nullrl_csr( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
22171: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
22172: chrId NUMBER,
22173: cleId NUMBER ) IS
22174: select crl.id
22175: from OKC_RULE_GROUPS_B crg,

Line 22176: OKC_RULES_B crl

22172: chrId NUMBER,
22173: cleId NUMBER ) IS
22174: select crl.id
22175: from OKC_RULE_GROUPS_B crg,
22176: OKC_RULES_B crl
22177: where crl.rgp_id = crg.id
22178: and crg.RGD_CODE = rgcode
22179: and crl.RULE_INFORMATION_CATEGORY = rlcat
22180: and crl.RULE_INFORMATION2 is null

Line 22420: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,

22416: l_lines_rec l_line_rec_csr%ROWTYPE;
22417: l_transaction_type VARCHAR2(256):= 'Miscellaneous';--'Generate Yields';
22418:
22419: cursor l_nullrl_csr( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
22420: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
22421: chrId NUMBER ) IS
22422: select crl.id
22423: from OKC_RULE_GROUPS_B crg,
22424: OKC_RULES_B crl

Line 22424: OKC_RULES_B crl

22420: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
22421: chrId NUMBER ) IS
22422: select crl.id
22423: from OKC_RULE_GROUPS_B crg,
22424: OKC_RULES_B crl
22425: where crl.rgp_id = crg.id
22426: and crg.RGD_CODE = rgcode
22427: and crl.RULE_INFORMATION_CATEGORY = rlcat
22428: and nvl(crl.RULE_INFORMATION1, 'XXX' ) = 'XXX'

Line 22843: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,

22839: x_stmv_rec Okl_Streams_pub.stmv_rec_type;
22840: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
22841:
22842: cursor l_rl_csr( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
22843: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
22844: chrId NUMBER,
22845: cleId NUMBER ) IS
22846: select crl.object1_id1,
22847: crl.RULE_INFORMATION1,

Line 22854: OKC_RULES_B crl

22850: crl.RULE_INFORMATION5,
22851: crl.RULE_INFORMATION6,
22852: crl.RULE_INFORMATION10
22853: from OKC_RULE_GROUPS_B crg,
22854: OKC_RULES_B crl
22855: where crl.rgp_id = crg.id
22856: and crg.RGD_CODE = rgcode
22857: and crl.RULE_INFORMATION_CATEGORY = rlcat
22858: and crg.dnz_chr_id = chrId

Line 22873: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,

22869: k NUMBER;
22870: temp NUMBER;
22871:
22872: cursor l_nullrl_csr( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
22873: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
22874: chrId NUMBER,
22875: cleId NUMBER ) IS
22876: select crl.id
22877: from OKC_RULE_GROUPS_B crg,

Line 22878: OKC_RULES_B crl

22874: chrId NUMBER,
22875: cleId NUMBER ) IS
22876: select crl.id
22877: from OKC_RULE_GROUPS_B crg,
22878: OKC_RULES_B crl
22879: where crl.rgp_id = crg.id
22880: and crg.RGD_CODE = rgcode
22881: and crl.RULE_INFORMATION_CATEGORY = rlcat
22882: and nvl(crl.RULE_INFORMATION1, 'XXX' ) = 'XXX'

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

23618: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_PAYMENTS';
23619: G_APP_NAME VARCHAR2(30) := 'OKL';
23620: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
23621: G_RGD_CODE okc_rule_groups_b.rgd_code%TYPE := 'LALEVL';
23622: G_RUL_SLH_CODE okc_rules_b.rule_information_category%TYPE := 'LASLH';
23623: G_RUL_SLL_CODE okc_rules_b.rule_information_category%TYPE := 'LASLL';
23624: G_FEE_TYPE okl_k_lines.fee_type%TYPE := 'PASSTHROUGH';
23625: -- Messages
23626: G_PAYMENT_OVERLAP_ERROR VARCHAR2(200) := 'OKL_PAYMENT_OVERLAP_ERROR';

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

23619: G_APP_NAME VARCHAR2(30) := 'OKL';
23620: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
23621: G_RGD_CODE okc_rule_groups_b.rgd_code%TYPE := 'LALEVL';
23622: G_RUL_SLH_CODE okc_rules_b.rule_information_category%TYPE := 'LASLH';
23623: G_RUL_SLL_CODE okc_rules_b.rule_information_category%TYPE := 'LASLL';
23624: G_FEE_TYPE okl_k_lines.fee_type%TYPE := 'PASSTHROUGH';
23625: -- Messages
23626: G_PAYMENT_OVERLAP_ERROR VARCHAR2(200) := 'OKL_PAYMENT_OVERLAP_ERROR';
23627: G_PAYMENT_GAP_ERROR VARCHAR2(200) := 'OKL_PAYMENT_GAP_ERROR';

Line 23658: FROM okc_rules_b slh,

23654: CURSOR c_get_pay_psth_csr(p_khr_id okl_k_headers.id%TYPE,
23655: p_kle_id okl_k_headers.id%TYPE)
23656: IS
23657: SELECT COUNT(*)
23658: FROM okc_rules_b slh,
23659: okc_rule_groups_b rgp,
23660: okl_k_lines kle
23661: WHERE rgp.dnz_chr_id = p_khr_id
23662: AND kle.id = p_kle_id

Line 23686: okc_rules_b rul

23682: p_cle_id okl_k_lines.id%TYPE)
23683: IS
23684: SELECT rul.id slh_id
23685: FROM okc_rule_groups_b rgp,
23686: okc_rules_b rul
23687: WHERE rul.rgp_id = rgp.id
23688: AND rgp.rgd_code = G_RGD_CODE
23689: AND rul.rule_information_category = G_RUL_SLH_CODE
23690: AND rgp.dnz_chr_id = p_khr_id

Line 23696: p_slh_id okc_rules_b.id%TYPE)

23692:
23693: -- Get all the SLL payment lines for Each Khr_id,SLH id and Line Id
23694: CURSOR c_get_sll_lines_csr(p_khr_id okl_k_headers.id%TYPE,
23695: p_cle_id okl_k_lines.id%TYPE,
23696: p_slh_id okc_rules_b.id%TYPE)
23697: IS
23698: SELECT FND_DATE.canonical_to_date(sll.rule_information2) start_date,
23699: /* DECODE(SLL.rule_information7,
23700: 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 23718: FROM okc_rules_b sll,

23714: -- End of BAKUCHIB modification bug#3121708
23715: sll.rule_information13 rate,
23716: nvl(sll.rule_information10,'Y') arrears_yn,
23717: sll.rule_information5 structure
23718: FROM okc_rules_b sll,
23719: okc_rules_b slh,
23720: okc_rule_groups_b rgp
23721: WHERE rgp.dnz_chr_id = p_khr_id
23722: AND rgp.cle_id = p_cle_id

Line 23719: okc_rules_b slh,

23715: sll.rule_information13 rate,
23716: nvl(sll.rule_information10,'Y') arrears_yn,
23717: sll.rule_information5 structure
23718: FROM okc_rules_b sll,
23719: okc_rules_b slh,
23720: okc_rule_groups_b rgp
23721: WHERE rgp.dnz_chr_id = p_khr_id
23722: AND rgp.cle_id = p_cle_id
23723: AND slh.id = p_slh_id

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

23737: WHERE EXISTS (SELECT 1
23738: FROM okc_k_headers_b
23739: WHERE id = p_khr_id);
23740: TYPE sll_date_rec_type IS RECORD (
23741: start_date okc_rules_b.last_update_date%TYPE := okl_api.G_MISS_DATE,
23742: end_date okc_rules_b.last_update_date%TYPE := okl_api.G_MISS_DATE);
23743: TYPE sll_date_tbl_type IS TABLE OF sll_date_rec_type
23744: INDEX BY BINARY_INTEGER;
23745: lt_sll_date_tbl_type sll_date_tbl_type;

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

23738: FROM okc_k_headers_b
23739: WHERE id = p_khr_id);
23740: TYPE sll_date_rec_type IS RECORD (
23741: start_date okc_rules_b.last_update_date%TYPE := okl_api.G_MISS_DATE,
23742: end_date okc_rules_b.last_update_date%TYPE := okl_api.G_MISS_DATE);
23743: TYPE sll_date_tbl_type IS TABLE OF sll_date_rec_type
23744: INDEX BY BINARY_INTEGER;
23745: lt_sll_date_tbl_type sll_date_tbl_type;
23746: l_paym_tbl OKL_STREAM_GENERATOR_PVT.payment_tbl_type := p_paym_tbl;

Line 24251: okc_rules_b rul_rv,

24247: FROM okc_k_headers_b chr_rv,
24248: okc_line_styles_b lse_rv,
24249: okl_k_lines kle_rv,
24250: okc_k_lines_b cle_rv,
24251: okc_rules_b rul_rv,
24252: okc_rule_groups_b rgp_rv,
24253: okc_line_styles_b lse_so,
24254: okc_k_lines_b cle_so,
24255: okc_rules_b rul_so,

Line 24255: okc_rules_b rul_so,

24251: okc_rules_b rul_rv,
24252: okc_rule_groups_b rgp_rv,
24253: okc_line_styles_b lse_so,
24254: okc_k_lines_b cle_so,
24255: okc_rules_b rul_so,
24256: okc_rule_groups_b rgp_so
24257: WHERE rgp_so.cle_id = p_kle_id
24258: AND rgp_so.dnz_chr_id = p_khr_id
24259: AND rgp_so.rgd_code = 'SOPYSC'

Line 24374: okc_rules_b rul_rv,

24370: FROM okc_k_headers_b chr_rv,
24371: okc_line_styles_b lse_rv,
24372: okl_k_lines kle_rv,
24373: okc_k_lines_b cle_rv,
24374: okc_rules_b rul_rv,
24375: okc_rule_groups_b rgp_rv,
24376: okc_line_styles_b lse_so,
24377: okc_k_lines_b cle_so,
24378: okc_rules_b rul_so,

Line 24378: okc_rules_b rul_so,

24374: okc_rules_b rul_rv,
24375: okc_rule_groups_b rgp_rv,
24376: okc_line_styles_b lse_so,
24377: okc_k_lines_b cle_so,
24378: okc_rules_b rul_so,
24379: okc_rule_groups_b rgp_so
24380: WHERE rgp_so.cle_id = p_kle_id
24381: AND rgp_so.dnz_chr_id = p_khr_id
24382: AND rgp_so.rgd_code = 'SOPYSC'

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

24709: l_capint OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
24710: l_discount OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
24711: l_corp_dep_cost OKL_TXL_ASSETS_B.DEPRECIATION_COST%TYPE := 0;
24712: l_tax_dep_cost OKL_TXD_ASSETS_B.COST%TYPE := 0;
24713: l_lease_tax_owner okc_rules_b.rule_information1%TYPE := NULL;
24714: -- get the Contract Header info
24715: CURSOR l_hdr_csr(chrId NUMBER)
24716: IS
24717: SELECT chr.orig_system_source_code,

Line 24736: rlcat okc_rules_b.rule_information_category%TYPE,

24732: AND chr.id = chrId
24733: AND khr.pdt_id = pdt.id(+);
24734: -- get the Header rule information
24735: CURSOR l_hdrrl_csr(rgcode okc_rule_groups_b.rgd_code%TYPE,
24736: rlcat okc_rules_b.rule_information_category%TYPE,
24737: chrId NUMBER)
24738: IS
24739: SELECT crl.object1_id1,
24740: crl.rule_information1,

Line 24750: okc_rules_b crl

24746: crl.rule_information10,
24747: crl.rule_information13,
24748: crl.rule_information11
24749: FROM okc_rule_groups_b crg,
24750: okc_rules_b crl
24751: WHERE crl.rgp_id = crg.id
24752: AND crg.rgd_code = rgcode
24753: AND crl.rule_information_category = rlcat
24754: AND crg.dnz_chr_id = chrId;

Line 24916: rlcat okc_rules_b.rule_information_category%TYPE,

24912: AND tl.language = 'US'
24913: AND stm.id = styid;
24914: -- get the LASLH self referencing Line based rule information
24915: CURSOR l_rl_csr1(rgcode okc_rule_groups_b.rgd_code%TYPE,
24916: rlcat okc_rules_b.rule_information_category%TYPE,
24917: chrId NUMBER,
24918: cleId NUMBER )
24919: IS
24920: SELECT crl.id slh_id,

Line 24932: okc_rules_b crl

24928: crl.rule_information8,
24929: crl.rule_information13,
24930: crl.rule_information10
24931: FROM okc_rule_groups_b crg,
24932: okc_rules_b crl
24933: WHERE crl.rgp_id = crg.id
24934: AND crg.rgd_code = rgcode
24935: AND crl.rule_information_category = rlcat
24936: AND crg.dnz_chr_id = chrId

Line 24942: rlcat okc_rules_b.rule_information_category%TYPE,

24938: ORDER BY crl.rule_information1;
24939: -- get the LASLL self referencing Line based rule information
24940: CURSOR l_rl_csr(rlgpId NUMBER,
24941: rgcode okc_rule_groups_b.rgd_code%TYPE,
24942: rlcat okc_rules_b.rule_information_category%TYPE,
24943: chrId NUMBER,
24944: cleId NUMBER )
24945: IS
24946: SELECT crl.object1_id1,

Line 24957: okc_rules_b crl

24953: crl.rule_information8,
24954: crl.rule_information13,
24955: crl.rule_information10
24956: FROM okc_rule_groups_b crg,
24957: okc_rules_b crl
24958: WHERE crl.rgp_id = crg.id
24959: AND crl.object2_id1 = rlgpId
24960: AND crg.rgd_code = rgcode
24961: AND crl.rule_information_category = rlcat

Line 24970: okc_rules_b crl

24966: CURSOR l_struct_csr(chrId NUMBER)
24967: IS
24968: SELECT DISTINCT(nvl(crl.rule_information5,-1)) structure
24969: FROM okc_rule_groups_b crg,
24970: okc_rules_b crl
24971: WHERE crl.rgp_id = crg.id
24972: AND crg.rgd_code = 'LALEVL'
24973: AND crl.rule_information_category = 'LASLL'
24974: AND crg.dnz_chr_id = chrId;

Line 25028: FROM okc_rules_b sll,

25024: MAX(DECODE(SLL.rule_information7,
25025: 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),
25026: TO_NUMBER(SLL.rule_information7),FND_DATE.canonical_to_date(sll.rule_information2)+SLL.rule_information7-1,
25027: (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
25028: FROM okc_rules_b sll,
25029: okc_rules_b slh,
25030: okc_rule_groups_b rgp,
25031: okc_k_headers_b chrv
25032: WHERE rgp.dnz_chr_id = p_chr_id

Line 25029: okc_rules_b slh,

25025: 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),
25026: TO_NUMBER(SLL.rule_information7),FND_DATE.canonical_to_date(sll.rule_information2)+SLL.rule_information7-1,
25027: (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
25028: FROM okc_rules_b sll,
25029: okc_rules_b slh,
25030: okc_rule_groups_b rgp,
25031: okc_k_headers_b chrv
25032: WHERE rgp.dnz_chr_id = p_chr_id
25033: AND rgp.cle_id = p_cle_id