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_RULE_GROUPS_B

Line 3084: FROM okc_rule_groups_b rgp,

3080: FND_NUMBER.canonical_to_number(rul2.rule_information6) amount,
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,

Line 3237: FROM okc_rule_groups_b rgp,

3233:
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'

Line 3847: FROM okc_rule_groups_b rgp

3843: CURSOR c_feepayment_freq(khrId NUMBER, cleId NUMBER) IS
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

Line 4175: FROM okc_rule_groups_b rgp

4171: CURSOR c_feepayment_freq(khrId NUMBER, cleId NUMBER) IS
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

Line 6160: FROM okc_rule_groups_b crg,

6156: SELECT distinct crg.cle_id line_id,
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

Line 6190: FROM okc_rule_groups_b crg,

6186: crl.RULE_INFORMATION7 STUB_DAYS,
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

Line 8646: FROM okc_rule_groups_b rgp,

8642: p_cle_id NUMBER)
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'

Line 11065: okc_rule_groups_b crg,

11061: SELECT crl.rule_information2 amount,
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'

Line 11130: rgcode okc_rule_groups_b.rgd_code%TYPE,

11126: AND styt.language = USERENV('lang');
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

Line 11140: FROM okc_rule_groups_b crg,

11136: -- Start of modification for Bug#3322910 BAKUCHIB Modified
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

Line 11225: FROM okc_rule_groups_b rgp,

11221: --Added by rgooty for bug 8399461
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'

Line 13840: from OKC_RULE_GROUPS_B crg,

13836: l_down_payment_amt NUMBER; --Added by bkatraga for bug 15942693
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'

Line 15267: from OKC_RULE_GROUPS_B crg,

15263:
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'

Line 15341: CURSOR get_prev_ppd_csr(rgcode okc_rule_groups_b.rgd_code%TYPE,

15337: l_prev_ppd NUMBER := 0;
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

Line 15357: FROM okc_rule_groups_b crg,

15353: crl.rule_information7,
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

Line 17552: from OKC_RULE_GROUPS_B crg,

17548:
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'

Line 17633: CURSOR get_prev_ppd_csr(rgcode okc_rule_groups_b.rgd_code%TYPE,

17629:
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

Line 17649: FROM okc_rule_groups_b crg,

17645: crl.rule_information7,
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

Line 19803: FROM okc_rule_groups_b crg,

19799: --This cursor determines whether there have been any Paydowns on this Contract
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'

Line 19910: FROM okc_rule_groups_b crg,

19906: CURSOR is_payment_available_csr(chrId NUMBER,
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'

Line 20133: okc_rule_groups_b rgpb

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'
20136: and sll_rulb.dnz_chr_id = rgpb.dnz_chr_id
20137: and sll_rulb.object2_id1 = to_char(slh_rulb.id)

Line 20192: CURSOR l_hdrrl_csr_lease(rgcode okc_rule_groups_b.rgd_code%TYPE,

20188: WHERE khr.id = chr.id
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,

Line 20206: FROM okc_rule_groups_b crg,

20202: crl.rule_information6,
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

Line 20318: CURSOR l_slh_csr_lease(rgcode okc_rule_groups_b.rgd_code%TYPE,

20314: AND trns.object1_id1 = books.book_type_code
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

Line 20334: FROM okc_rule_groups_b crg,

20330: crl.rule_information7,
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

Line 20358: rgcode okc_rule_groups_b.rgd_code%TYPE,

20354: AND tl.language = 'US'
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

Line 20373: FROM okc_rule_groups_b crg,

20369: crl.rule_information7,
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

Line 22170: cursor l_nullrl_csr( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,

22166: l_lines_rec l_line_rec_csr%ROWTYPE;
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

Line 22175: from OKC_RULE_GROUPS_B crg,

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,
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

Line 22419: cursor l_nullrl_csr( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,

22415: i NUMBER;
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,

Line 22423: from OKC_RULE_GROUPS_B crg,

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
22425: where crl.rgp_id = crg.id
22426: and crg.RGD_CODE = rgcode
22427: and crl.RULE_INFORMATION_CATEGORY = rlcat

Line 22842: cursor l_rl_csr( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,

22838: l_selv_tbl Okl_Streams_pub.selv_tbl_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,

Line 22853: from OKC_RULE_GROUPS_B crg,

22849: crl.RULE_INFORMATION3,
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

Line 22872: cursor l_nullrl_csr( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,

22868: j NUMBER;
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

Line 22877: from OKC_RULE_GROUPS_B crg,

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,
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

Line 23621: G_RGD_CODE okc_rule_groups_b.rgd_code%TYPE := 'LALEVL';

23617: IS
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

Line 23659: okc_rule_groups_b rgp,

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
23663: AND rgp.rgd_code= G_RGD_CODE

Line 23685: FROM okc_rule_groups_b rgp,

23681: CURSOR c_get_slh_lines_csr(p_khr_id okl_k_headers.id%TYPE,
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

Line 23720: okc_rule_groups_b rgp

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
23724: AND rgp.rgd_code = G_RGD_CODE

Line 24252: okc_rule_groups_b rgp_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,
24256: okc_rule_groups_b rgp_so

Line 24256: okc_rule_groups_b rgp_so

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'
24260: AND rgp_so.dnz_chr_id = rul_so.dnz_chr_id

Line 24375: okc_rule_groups_b rgp_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,
24379: okc_rule_groups_b rgp_so

Line 24379: okc_rule_groups_b rgp_so

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'
24383: AND rgp_so.dnz_chr_id = rul_so.dnz_chr_id

Line 24735: CURSOR l_hdrrl_csr(rgcode okc_rule_groups_b.rgd_code%TYPE,

24731: WHERE khr.id = chr.id
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,

Line 24749: FROM okc_rule_groups_b crg,

24745: crl.rule_information6,
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

Line 24915: CURSOR l_rl_csr1(rgcode okc_rule_groups_b.rgd_code%TYPE,

24911: WHERE tl.id = stm.id
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

Line 24931: FROM okc_rule_groups_b crg,

24927: crl.rule_information7,
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

Line 24941: rgcode okc_rule_groups_b.rgd_code%TYPE,

24937: AND crg.cle_id = cleId
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

Line 24956: FROM okc_rule_groups_b crg,

24952: crl.rule_information7,
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

Line 24969: FROM okc_rule_groups_b crg,

24965: -- Get Structure
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'

Line 25020: p_slh_id okc_rule_groups_b.id%TYPE)

25016: -- Get diff in days between contract end_date
25017: -- and max payment leve(LASLL) end_date
25018: CURSOR c_diff_days_csr(p_chr_id okc_k_headers_b.id%TYPE,
25019: p_cle_id okc_k_lines_b.id%TYPE,
25020: p_slh_id okc_rule_groups_b.id%TYPE)
25021: IS
25022: SELECT chrv.end_date chr_end_date,
25023: MAX(FND_DATE.canonical_to_date(sll.rule_information2)) pay_start_date,
25024: MAX(DECODE(SLL.rule_information7,

Line 25030: okc_rule_groups_b rgp,

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
25034: AND slh.id = p_slh_id