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_STREAM_GENERATOR_PVT dependencies on OKC_RULE_GROUPS_B

Line 53: Cursor G_ROLLOVER_PMNTS(p_khr_id OKC_RULE_GROUPS_B.dnz_chr_id%type ) IS

49: and chr.id = p_khr_id
50: and khr.pdt_id = pdt.id(+);
51: r_hdr G_HDR%ROWTYPE;
52:
53: Cursor G_ROLLOVER_PMNTS(p_khr_id OKC_RULE_GROUPS_B.dnz_chr_id%type ) IS
54: Select distinct nvl(slh.object1_id1, -1) styId
55: From OKC_RULE_GROUPS_B rgp,
56: OKC_RULES_B sll,
57: okc_rules_b slh,

Line 55: From OKC_RULE_GROUPS_B rgp,

51: r_hdr G_HDR%ROWTYPE;
52:
53: Cursor G_ROLLOVER_PMNTS(p_khr_id OKC_RULE_GROUPS_B.dnz_chr_id%type ) IS
54: Select distinct nvl(slh.object1_id1, -1) styId
55: From OKC_RULE_GROUPS_B rgp,
56: OKC_RULES_B sll,
57: okc_rules_b slh,
58: okl_strm_type_b sty
59: Where slh.rgp_id = rgp.id

Line 786: okc_rule_groups_b rgp,

782: okl_k_lines kle,
783: okc_line_styles_b lse,
784: okc_rules_b sll,
785: okc_rules_b slh,
786: okc_rule_groups_b rgp,
787: okl_strm_type_b stm
788: WHERE chr_so.id = p_khr_id
789: and cle.sts_code in( 'COMPLETE', 'INCOMPLETE')--'ENTERED'
790: AND cle.dnz_chr_id = chr_so.id

Line 1681: From OKC_RULE_GROUPS_B rgp,

1677: inc_strms_tbl inc_strms_tbl_type;
1678: lastDate DATE := NULL;
1679: Cursor c_rollover_pmnts IS
1680: Select distinct nvl(slh.object1_id1, -1) styId
1681: From OKC_RULE_GROUPS_B rgp,
1682: OKC_RULES_B sll,
1683: okc_rules_b slh,
1684: okl_strm_type_b sty
1685: Where slh.rgp_id = rgp.id

Line 1834: okc_rule_groups_b rgp

1830: Function Is_Var_Rate_Contract (p_chr_id in number) Return Varchar2 is
1831: Cursor get_rul_csr(p_chr_id in Number, p_rule_code in varchar2, p_rgd_code in varchar2) is
1832: Select rul.*
1833: from okc_rules_b rul,
1834: okc_rule_groups_b rgp
1835: where rul.rgp_id = rgp.id
1836: and rul.rule_information_category = p_rule_code
1837: and rul.dnz_chr_id = rgp.dnz_chr_id
1838: and rgp.chr_id = p_chr_id

Line 2040: From OKC_RULE_GROUPS_B rgp,

2036: r_hdr c_hdr%ROWTYPE;
2037:
2038: Cursor c_rollover_pmnts IS
2039: Select distinct nvl(slh.object1_id1, -1) styId
2040: From OKC_RULE_GROUPS_B rgp,
2041: OKC_RULES_B sll,
2042: okc_rules_b slh,
2043: okl_strm_type_b sty
2044: Where slh.rgp_id = rgp.id

Line 2869: FROM okc_rule_groups_b rgp,

2865: p_recurrence_date IN DATE) IS
2866:
2867: CURSOR c_pt_perc( kleid NUMBER) IS
2868: SELECT NVL(TO_NUMBER(rul.rule_information1), 100) pass_through_percentage
2869: FROM okc_rule_groups_b rgp,
2870: okc_rules_b rul
2871: WHERE rgp.cle_id = kleid
2872: AND rgp.rgd_code = 'LAPSTH'
2873: AND rgp.id = rul.rgp_id

Line 4028: From OKC_RULE_GROUPS_B rgp,

4024:
4025:
4026: Cursor c_rollover_pmnts( chrId NUMBER, kleId NUMBER ) IS
4027: Select nvl(slh.object1_id1, -1) styId
4028: From OKC_RULE_GROUPS_B rgp,
4029: OKC_RULES_B sll,
4030: okc_rules_b slh,
4031: okl_strm_type_b sty
4032: Where slh.rgp_id = rgp.id

Line 4049: FROM okc_rule_groups_b rgp,

4045:
4046: CURSOR c_inflows( khrId NUMBER, kleId NUMBER) IS
4047: SELECT rul2.object1_id1 frequency,
4048: DECODE(rul2.rule_information10, 'Y', 'ARREARS', 'ADVANCE') advance_arrears
4049: FROM okc_rule_groups_b rgp,
4050: okc_rules_b rul1,
4051: okc_rules_b rul2,
4052: okc_k_lines_b cle,
4053: okl_k_lines kle,

Line 4115: okc_rule_groups_b rgp

4111: okc_k_lines_b cle,
4112: okc_line_styles_b lse,
4113: okc_rules_b sll,
4114: okc_rules_b slh,
4115: okc_rule_groups_b rgp
4116: WHERE stm.khr_id = khrId
4117: AND stm.kle_id = kleId
4118: AND stm.say_code = 'WORK'
4119: AND nvl(stm.purpose_code, '-99') = pCode

Line 4126: FROM okc_rule_groups_b rgp2

4122: AND sty.stream_type_purpose IN ( 'RENT', 'LOAN_PAYMENT')
4123: AND sel.comments IS NOT NULL
4124: AND stm.kle_id = cle.id
4125: AND NOT EXISTS (SELECT 1
4126: FROM okc_rule_groups_b rgp2
4127: WHERE rgp2.dnz_chr_id = khrId
4128: AND rgp2.cle_id = cle.id
4129: AND rgp2.rgd_code = 'LAPSTH')
4130: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED')

Line 5249: FROM okc_rule_groups_b rgp,

5245: lse.lty_code lty_code,
5246: kle.capital_amount capital_amount,
5247: kle.residual_value residual_value,
5248: kle.fee_type fee_type
5249: FROM okc_rule_groups_b rgp,
5250: okc_rules_b rul1,
5251: okc_rules_b rul2,
5252: okc_k_lines_b cle,
5253: okl_k_lines kle,

Line 5281: FROM okc_rule_groups_b rgp,

5277: NULL lty_code,
5278: TO_NUMBER(NULL) capital_amount,
5279: TO_NUMBER(NULL) residual_value,
5280: NULL fee_type
5281: FROM okc_rule_groups_b rgp,
5282: okc_rules_b rul1,
5283: okc_rules_b rul2
5284: WHERE
5285: rul2.dnz_chr_id = p_khr_id

Line 5312: FROM okc_rule_groups_b

5308:
5309:
5310: CURSOR c_pt_yn (p_cle_id NUMBER) IS
5311: SELECT 'Y'
5312: FROM okc_rule_groups_b
5313: WHERE cle_id = p_cle_id
5314: AND rgd_code = 'LAPSTH';
5315:
5316: l_pt_yn VARCHAR2(1);

Line 5914: FROM okc_rule_groups_b rgp,

5910: TO_NUMBER(rul2.rule_information3) periods,
5911: FND_NUMBER.canonical_to_number(rul2.rule_information6) amount,
5912: TO_NUMBER(rul2.rule_information7) stub_days,
5913: TO_NUMBER(rul2.rule_information8) stub_amount
5914: FROM okc_rule_groups_b rgp,
5915: okc_rules_b rul1,
5916: okc_rules_b rul2,
5917: okc_k_lines_b cle,
5918: okl_strm_type_b sty

Line 7007: FROM okc_rule_groups_b rgp,

7003: -- Case: When Payment Level is Regular Periods
7004: ,FND_DATE.canonical_to_date(sll.rule_information2)
7005: + TO_NUMBER(sll.rule_information7) - 1
7006: ) end_date
7007: FROM okc_rule_groups_b rgp,
7008: okc_rules_b slh,
7009: okc_rules_b sll,
7010: okl_strm_type_b sty
7011: WHERE sll.dnz_chr_id = p_khr_id

Line 7042: okc_rule_groups_b rgp,

7038: * DECODE(rul2.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12, NULL)
7039: ) - 1 ) end_date
7040: FROM okc_rules_b rul,
7041: okc_rules_b rul2,
7042: okc_rule_groups_b rgp,
7043: okc_k_lines_b cle,
7044: okl_k_lines kle
7045: WHERE cle.id = p_kle_id
7046: AND cle.sts_code IN ('NEW', 'INCOMPLETE', 'PASSED', 'COMPLETE')

Line 7108: FROM OKC_RULE_GROUPS_B rgp,

7104: -- Cursor: Spread By Income Logic: To identify the Stream Type used for Authoring the Asset Payments
7105: CURSOR l_rent_pri_sty_name_csr
7106: IS
7107: SELECT DISTINCT NVL(slh.object1_id1, -1) styid
7108: FROM OKC_RULE_GROUPS_B rgp,
7109: OKC_RULES_B sll,
7110: okc_rules_b slh,
7111: okl_strm_type_b sty
7112: WHERE slh.rgp_id = rgp.id

Line 8036: FROM okc_rule_groups_b rgp,

8032:
8033: CURSOR c_niv (kleId NUMBER) IS
8034: SELECT FND_NUMBER.canonical_to_number(rul2.rule_information6) amount,
8035: TO_NUMBER(rul2.rule_information8) stub_amount
8036: FROM okc_rule_groups_b rgp,
8037: okc_rules_b rul1,
8038: okc_rules_b rul2,
8039: okc_k_lines_b cle,
8040: okl_k_lines kle,

Line 8085: okc_rule_groups_b rgp,

8081: FROM okc_k_lines_b cle,
8082: okl_k_lines kle,
8083: okc_line_styles_b lse,
8084: okl_strm_type_b sty,
8085: okc_rule_groups_b rgp,
8086: okc_rules_b rul1
8087: WHERE
8088: rul1.dnz_chr_id = p_khr_id
8089: AND rul1.rule_information_category = 'LASLH'

Line 8119: FROM okc_rule_groups_b rgp,

8115: kle.fee_type fee_type,
8116: kle.origination_income origination_income,
8117: kle.amount fee_amount,
8118: DECODE(kle.fee_type, 'INCOME', 'INCOME_ACCRUED', 'FEE_PAYMENT') fee_line_level_type
8119: FROM okc_rule_groups_b rgp,
8120: okc_rules_b rul1,
8121: okc_rules_b rul2,
8122: okc_k_lines_b cle,
8123: okl_k_lines kle,

Line 8155: FROM okc_rule_groups_b rgp,

8151: NULL fee_type,
8152: NULL origination_income,
8153: NULL fee_amount,
8154: 'ASSET_ACCRUALS' fee_line_level_type
8155: FROM okc_rule_groups_b rgp,
8156: okc_rules_b rul1,
8157: okc_rules_b rul2,
8158: okl_strm_type_b sty
8159: WHERE

Line 8204: From OKC_RULE_GROUPS_B rgp,

8200: top_svc_rec top_svc_csr%ROWTYPE;
8201:
8202: Cursor c_rollover_pmnts( chrId NUMBER, kleId NUMBER ) IS
8203: Select nvl(slh.object1_id1, -1) styId
8204: From OKC_RULE_GROUPS_B rgp,
8205: OKC_RULES_B sll,
8206: okc_rules_b slh,
8207: okl_strm_type_b sty
8208: Where slh.rgp_id = rgp.id

Line 8224: From OKC_RULE_GROUPS_B crg,

8220: r_rollover_pmnts c_rollover_pmnts%ROWTYPE;
8221:
8222: Cursor c_link_pmnts( chrId NUMBER, kleId NUMBER ) IS
8223: Select nvl(slh.object1_id1, -1) styId
8224: From OKC_RULE_GROUPS_B crg,
8225: OKC_RULES_B crl,
8226: okc_rules_b slh,
8227: okc_K_lines_b cle_lnk,
8228: okl_K_lines kle_roll

Line 8366: okc_rule_groups_b rgp

8362:
8363: CURSOR c_rent_sty_id (finfeesId NUMBER) IS
8364: SELECT slh.object1_id1
8365: FROM okc_rules_b slh,
8366: okc_rule_groups_b rgp
8367: WHERE rgp.dnz_chr_id = p_khr_id
8368: AND rgp.cle_id = finfeesId
8369: AND rgp.rgd_code= 'LALEVL'
8370: AND rgp.id = slh.rgp_id

Line 8378: okc_rule_groups_b rgp,

8374: -- bug 13013062: cursor added. get the rent stream type id
8375: CURSOR get_rent_sty_id (p_khr_id NUMBER) IS
8376: SELECT slh.object1_id1
8377: FROM okc_rules_b slh,
8378: okc_rule_groups_b rgp,
8379: okl_strm_type_b stm
8380: WHERE rgp.dnz_chr_id = p_khr_id
8381: AND rgp.rgd_code= 'LALEVL'
8382: AND rgp.id = slh.rgp_id

Line 10359: FROM okc_rule_groups_b rgp,

10355: TO_NUMBER(rul2.rule_information8) stub_amount,
10356: NULL lty_code,
10357: TO_NUMBER(NULL) capital_amount,
10358: TO_NUMBER(NULL) residual_value
10359: FROM okc_rule_groups_b rgp,
10360: okc_rules_b rul1,
10361: okc_rules_b rul2,
10362: okl_strm_type_tl sty
10363: WHERE rul2.dnz_chr_id = khrid

Line 10773: from OKC_RULE_GROUPS_B crg,

10769: lx_stmv_rec okl_streams_pub.stmv_rec_type;
10770:
10771: cursor l_hdrrl_csr IS
10772: select crl.RULE_INFORMATION1 method
10773: from OKC_RULE_GROUPS_B crg,
10774: OKC_RULES_B crl
10775: where crl.rgp_id = crg.id
10776: and crg.RGD_CODE = 'LASEIR'
10777: and crl.RULE_INFORMATION_CATEGORY = 'LASEIR'

Line 11440: from OKC_RULE_GROUPS_B crg,

11436: lx_stmv_rec okl_streams_pub.stmv_rec_type;
11437:
11438: cursor l_hdrrl_csr IS
11439: select crl.RULE_INFORMATION1 method
11440: from OKC_RULE_GROUPS_B crg,
11441: OKC_RULES_B crl
11442: where crl.rgp_id = crg.id
11443: and crg.RGD_CODE = 'LASEIR'
11444: and crl.RULE_INFORMATION_CATEGORY = 'LASEIR'

Line 13468: okc_rule_groups_b rgp

13464: sll.object1_id1 frequency,
13465: nvl(sll.rule_information10, 'N') advance_arrears
13466: FROM okc_rules_b sll,
13467: okc_rules_b slh,
13468: okc_rule_groups_b rgp
13469: WHERE rgp.rgd_code = 'LALEVL'
13470: AND rgp.id = slh.rgp_id
13471: AND slh.rule_information_category = 'LASLH'
13472: AND slh.object1_id1 = styId

Line 13513: okc_rule_groups_b rgp,

13509: cursor fee_strm_type_csr is
13510: SELECT sty.id
13511: FROM okc_rules_b sll,
13512: okc_rules_b slh,
13513: okc_rule_groups_b rgp,
13514: okl_strm_type_b sty
13515: WHERE rgp.dnz_chr_id = p_khr_id
13516: AND rgp.cle_id = p_kle_id
13517: AND rgp.rgd_code= 'LALEVL'

Line 13790: FROM okc_rule_groups_b rgp,

13786: TO_NUMBER(rul2.rule_information8) stub_amount,
13787: NULL lty_code,
13788: TO_NUMBER(NULL) capital_amount,
13789: TO_NUMBER(NULL) residual_value
13790: FROM okc_rule_groups_b rgp,
13791: okc_rules_b rul1,
13792: okc_rules_b rul2,
13793: okl_strm_type_b sty
13794: WHERE rul2.dnz_chr_id = khrid

Line 14076: FROM okc_rule_groups_b rgp,

14072: lse.lty_code lty_code,
14073: kle.capital_amount capital_amount,
14074: kle.residual_value residual_value,
14075: kle.fee_type fee_type
14076: FROM okc_rule_groups_b rgp,
14077: okc_rules_b rul1,
14078: okc_rules_b rul2,
14079: okc_k_lines_b cle,
14080: okl_k_lines kle,

Line 14306: FROM okc_rule_groups_b rgp,

14302: lse.lty_code lty_code,
14303: kle.capital_amount capital_amount,
14304: kle.residual_value residual_value,
14305: kle.fee_type fee_type
14306: FROM okc_rule_groups_b rgp,
14307: okc_rules_b rul1,
14308: okc_rules_b rul2,
14309: okc_k_lines_b cle,
14310: okl_k_lines kle,