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 2668: FROM okc_rule_groups_b rgp,

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

Line 5059: FROM okc_rule_groups_b crg,

5055: CURSOR l_struct_csr(chrId NUMBER , styId NUMBER)
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'

Line 5086: FROM okc_rule_groups_b crg,

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

Line 7152: FROM okc_rule_groups_b rgp,

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

Line 9479: okc_rule_groups_b crg,

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

Line 9542: rgcode okc_rule_groups_b.rgd_code%TYPE,

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

Line 9552: FROM okc_rule_groups_b crg,

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

Line 11910: from OKC_RULE_GROUPS_B crg,

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

Line 13164: from OKC_RULE_GROUPS_B crg,

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

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

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

Line 13254: FROM okc_rule_groups_b crg,

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

Line 15239: from OKC_RULE_GROUPS_B crg,

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

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

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

Line 15328: FROM okc_rule_groups_b crg,

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

Line 17198: FROM okc_rule_groups_b crg,

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

Line 17304: FROM okc_rule_groups_b crg,

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

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

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

Line 17572: FROM okc_rule_groups_b crg,

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

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

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

Line 17696: FROM okc_rule_groups_b crg,

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

Line 17720: rgcode okc_rule_groups_b.rgd_code%TYPE,

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

Line 17735: FROM okc_rule_groups_b crg,

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

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

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

Line 19384: from OKC_RULE_GROUPS_B crg,

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

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

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

Line 19630: from OKC_RULE_GROUPS_B crg,

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
19632: where crl.rgp_id = crg.id
19633: and crg.RGD_CODE = rgcode
19634: and crl.RULE_INFORMATION_CATEGORY = rlcat

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

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

Line 20045: from OKC_RULE_GROUPS_B crg,

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

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

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

Line 20069: from OKC_RULE_GROUPS_B crg,

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

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

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

Line 20823: okc_rule_groups_b rgp,

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

Line 20849: FROM okc_rule_groups_b rgp,

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

Line 20884: okc_rule_groups_b rgp

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

Line 21409: okc_rule_groups_b rgp_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,
21413: okc_rule_groups_b rgp_so

Line 21413: okc_rule_groups_b rgp_so

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

Line 21532: okc_rule_groups_b rgp_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,
21536: okc_rule_groups_b rgp_so

Line 21536: okc_rule_groups_b rgp_so

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

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

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

Line 21906: FROM okc_rule_groups_b crg,

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

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

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

Line 22088: FROM okc_rule_groups_b crg,

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

Line 22098: rgcode okc_rule_groups_b.rgd_code%TYPE,

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

Line 22113: FROM okc_rule_groups_b crg,

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

Line 22126: FROM okc_rule_groups_b crg,

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

Line 22177: p_slh_id okc_rule_groups_b.id%TYPE)

22173: -- Get diff in days between contract end_date
22174: -- and max payment leve(LASLL) end_date
22175: CURSOR c_diff_days_csr(p_chr_id okc_k_headers_b.id%TYPE,
22176: p_cle_id okc_k_lines_b.id%TYPE,
22177: p_slh_id okc_rule_groups_b.id%TYPE)
22178: IS
22179: SELECT chrv.end_date chr_end_date,
22180: MAX(FND_DATE.canonical_to_date(sll.rule_information2)) pay_start_date,
22181: MAX(DECODE(SLL.rule_information7,

Line 22187: okc_rule_groups_b rgp,

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