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_RULES_B

Line 52: OKC_RULES_B sll,

48:
49: Cursor G_ROLLOVER_PMNTS(p_khr_id OKC_RULE_GROUPS_B.dnz_chr_id%type ) IS
50: Select distinct nvl(slh.object1_id1, -1) styId
51: From OKC_RULE_GROUPS_B rgp,
52: OKC_RULES_B sll,
53: okc_rules_b slh,
54: okl_strm_type_b sty
55: Where slh.rgp_id = rgp.id
56: and rgp.RGD_CODE = 'LALEVL'

Line 53: okc_rules_b slh,

49: Cursor G_ROLLOVER_PMNTS(p_khr_id OKC_RULE_GROUPS_B.dnz_chr_id%type ) IS
50: Select distinct nvl(slh.object1_id1, -1) styId
51: From OKC_RULE_GROUPS_B rgp,
52: OKC_RULES_B sll,
53: okc_rules_b slh,
54: okl_strm_type_b sty
55: Where slh.rgp_id = rgp.id
56: and rgp.RGD_CODE = 'LALEVL'
57: and sll.RULE_INFORMATION_CATEGORY = 'LASLL'

Line 775: okc_rules_b sll,

771: FROM okc_k_headers_b chr_so,
772: okc_k_lines_b cle,
773: okl_k_lines kle,
774: okc_line_styles_b lse,
775: okc_rules_b sll,
776: okc_rules_b slh,
777: okc_rule_groups_b rgp,
778: okl_strm_type_b stm
779: WHERE chr_so.id = p_khr_id

Line 776: okc_rules_b slh,

772: okc_k_lines_b cle,
773: okl_k_lines kle,
774: okc_line_styles_b lse,
775: okc_rules_b sll,
776: okc_rules_b slh,
777: okc_rule_groups_b rgp,
778: okl_strm_type_b stm
779: WHERE chr_so.id = p_khr_id
780: and cle.sts_code in( 'COMPLETE', 'INCOMPLETE')--'ENTERED'

Line 1667: OKC_RULES_B sll,

1663: lastDate DATE := NULL;
1664: Cursor c_rollover_pmnts IS
1665: Select distinct nvl(slh.object1_id1, -1) styId
1666: From OKC_RULE_GROUPS_B rgp,
1667: OKC_RULES_B sll,
1668: okc_rules_b slh,
1669: okl_strm_type_b sty
1670: Where slh.rgp_id = rgp.id
1671: and rgp.RGD_CODE = 'LALEVL'

Line 1668: okc_rules_b slh,

1664: Cursor c_rollover_pmnts IS
1665: Select distinct nvl(slh.object1_id1, -1) styId
1666: From OKC_RULE_GROUPS_B rgp,
1667: OKC_RULES_B sll,
1668: okc_rules_b slh,
1669: okl_strm_type_b sty
1670: Where slh.rgp_id = rgp.id
1671: and rgp.RGD_CODE = 'LALEVL'
1672: and sll.RULE_INFORMATION_CATEGORY = 'LASLL'

Line 1818: from okc_rules_b rul,

1814:
1815: Function Is_Var_Rate_Contract (p_chr_id in number) Return Varchar2 is
1816: Cursor get_rul_csr(p_chr_id in Number, p_rule_code in varchar2, p_rgd_code in varchar2) is
1817: Select rul.*
1818: from okc_rules_b rul,
1819: okc_rule_groups_b rgp
1820: where rul.rgp_id = rgp.id
1821: and rul.rule_information_category = p_rule_code
1822: and rul.dnz_chr_id = rgp.dnz_chr_id

Line 2026: OKC_RULES_B sll,

2022:
2023: Cursor c_rollover_pmnts IS
2024: Select distinct nvl(slh.object1_id1, -1) styId
2025: From OKC_RULE_GROUPS_B rgp,
2026: OKC_RULES_B sll,
2027: okc_rules_b slh,
2028: okl_strm_type_b sty
2029: Where slh.rgp_id = rgp.id
2030: and rgp.RGD_CODE = 'LALEVL'

Line 2027: okc_rules_b slh,

2023: Cursor c_rollover_pmnts IS
2024: Select distinct nvl(slh.object1_id1, -1) styId
2025: From OKC_RULE_GROUPS_B rgp,
2026: OKC_RULES_B sll,
2027: okc_rules_b slh,
2028: okl_strm_type_b sty
2029: Where slh.rgp_id = rgp.id
2030: and rgp.RGD_CODE = 'LALEVL'
2031: and sll.RULE_INFORMATION_CATEGORY = 'LASLL'

Line 2994: okc_rules_b rul

2990:
2991: CURSOR c_pt_perc( kleid NUMBER) IS
2992: SELECT NVL(TO_NUMBER(rul.rule_information1), 100) pass_through_percentage
2993: FROM okc_rule_groups_b rgp,
2994: okc_rules_b rul
2995: WHERE rgp.cle_id = kleid
2996: AND rgp.rgd_code = 'LAPSTH'
2997: AND rgp.id = rul.rgp_id
2998: AND rul.rule_information_category = 'LAPTPR';

Line 4114: OKC_RULES_B sll,

4110:
4111: Cursor c_rollover_pmnts( chrId NUMBER, kleId NUMBER ) IS
4112: Select nvl(slh.object1_id1, -1) styId
4113: From OKC_RULE_GROUPS_B rgp,
4114: OKC_RULES_B sll,
4115: okc_rules_b slh,
4116: okl_strm_type_b sty
4117: Where slh.rgp_id = rgp.id
4118: and rgp.RGD_CODE = 'LALEVL'

Line 4115: okc_rules_b slh,

4111: Cursor c_rollover_pmnts( chrId NUMBER, kleId NUMBER ) IS
4112: Select nvl(slh.object1_id1, -1) styId
4113: From OKC_RULE_GROUPS_B rgp,
4114: OKC_RULES_B sll,
4115: okc_rules_b slh,
4116: okl_strm_type_b sty
4117: Where slh.rgp_id = rgp.id
4118: and rgp.RGD_CODE = 'LALEVL'
4119: and sll.RULE_INFORMATION_CATEGORY = 'LASLL'

Line 4134: okc_rules_b rul1,

4130: CURSOR c_inflows( khrId NUMBER, kleId NUMBER) IS
4131: SELECT rul2.object1_id1 frequency,
4132: DECODE(rul2.rule_information10, 'Y', 'ARREARS', 'ADVANCE') advance_arrears
4133: FROM okc_rule_groups_b rgp,
4134: okc_rules_b rul1,
4135: okc_rules_b rul2,
4136: okc_k_lines_b cle,
4137: okl_k_lines kle,
4138: okc_line_styles_b lse,

Line 4135: okc_rules_b rul2,

4131: SELECT rul2.object1_id1 frequency,
4132: DECODE(rul2.rule_information10, 'Y', 'ARREARS', 'ADVANCE') advance_arrears
4133: FROM okc_rule_groups_b rgp,
4134: okc_rules_b rul1,
4135: okc_rules_b rul2,
4136: okc_k_lines_b cle,
4137: okl_k_lines kle,
4138: okc_line_styles_b lse,
4139: okl_strm_type_b sty

Line 4197: okc_rules_b sll,

4193: okl_strm_type_b sty,
4194: okl_strm_elements sel,
4195: okc_k_lines_b cle,
4196: okc_line_styles_b lse,
4197: okc_rules_b sll,
4198: okc_rules_b slh,
4199: okc_rule_groups_b rgp
4200: WHERE stm.khr_id = khrId
4201: AND stm.kle_id = kleId

Line 4198: okc_rules_b slh,

4194: okl_strm_elements sel,
4195: okc_k_lines_b cle,
4196: okc_line_styles_b lse,
4197: okc_rules_b sll,
4198: okc_rules_b slh,
4199: okc_rule_groups_b rgp
4200: WHERE stm.khr_id = khrId
4201: AND stm.kle_id = kleId
4202: AND stm.say_code = 'WORK'

Line 5328: okc_rules_b rul1,

5324: kle.capital_amount capital_amount,
5325: kle.residual_value residual_value,
5326: kle.fee_type fee_type
5327: FROM okc_rule_groups_b rgp,
5328: okc_rules_b rul1,
5329: okc_rules_b rul2,
5330: okc_k_lines_b cle,
5331: okl_k_lines kle,
5332: okc_line_styles_b lse

Line 5329: okc_rules_b rul2,

5325: kle.residual_value residual_value,
5326: kle.fee_type fee_type
5327: FROM okc_rule_groups_b rgp,
5328: okc_rules_b rul1,
5329: okc_rules_b rul2,
5330: okc_k_lines_b cle,
5331: okl_k_lines kle,
5332: okc_line_styles_b lse
5333: WHERE

Line 5360: okc_rules_b rul1,

5356: TO_NUMBER(NULL) capital_amount,
5357: TO_NUMBER(NULL) residual_value,
5358: NULL fee_type
5359: FROM okc_rule_groups_b rgp,
5360: okc_rules_b rul1,
5361: okc_rules_b rul2
5362: WHERE
5363: rul2.dnz_chr_id = p_khr_id
5364: AND rul2.rule_information_category = 'LASLL'

Line 5361: okc_rules_b rul2

5357: TO_NUMBER(NULL) residual_value,
5358: NULL fee_type
5359: FROM okc_rule_groups_b rgp,
5360: okc_rules_b rul1,
5361: okc_rules_b rul2
5362: WHERE
5363: rul2.dnz_chr_id = p_khr_id
5364: AND rul2.rule_information_category = 'LASLL'
5365: AND rul1.rule_information_category = 'LASLH'

Line 6011: okc_rules_b rul1,

6007: CURSOR c_niv (kleId NUMBER) IS
6008: SELECT FND_NUMBER.canonical_to_number(rul2.rule_information6) amount,
6009: TO_NUMBER(rul2.rule_information8) stub_amount
6010: FROM okc_rule_groups_b rgp,
6011: okc_rules_b rul1,
6012: okc_rules_b rul2,
6013: okc_k_lines_b cle,
6014: okl_k_lines kle,
6015: okc_line_styles_b lse,

Line 6012: okc_rules_b rul2,

6008: SELECT FND_NUMBER.canonical_to_number(rul2.rule_information6) amount,
6009: TO_NUMBER(rul2.rule_information8) stub_amount
6010: FROM okc_rule_groups_b rgp,
6011: okc_rules_b rul1,
6012: okc_rules_b rul2,
6013: okc_k_lines_b cle,
6014: okl_k_lines kle,
6015: okc_line_styles_b lse,
6016: okl_strm_type_b sty

Line 6049: okc_rules_b rul1,

6045: kle.capital_amount capital_amount,
6046: kle.residual_value residual_value,
6047: kle.fee_type fee_type
6048: FROM okc_rule_groups_b rgp,
6049: okc_rules_b rul1,
6050: okc_rules_b rul2,
6051: okc_k_lines_b cle,
6052: okl_k_lines kle,
6053: okc_line_styles_b lse,

Line 6050: okc_rules_b rul2,

6046: kle.residual_value residual_value,
6047: kle.fee_type fee_type
6048: FROM okc_rule_groups_b rgp,
6049: okc_rules_b rul1,
6050: okc_rules_b rul2,
6051: okc_k_lines_b cle,
6052: okl_k_lines kle,
6053: okc_line_styles_b lse,
6054: okl_strm_type_b sty

Line 6082: okc_rules_b rul1,

6078: TO_NUMBER(NULL) capital_amount,
6079: TO_NUMBER(NULL) residual_value,
6080: NULL fee_type
6081: FROM okc_rule_groups_b rgp,
6082: okc_rules_b rul1,
6083: okc_rules_b rul2,
6084: okl_strm_type_b sty
6085: WHERE
6086: rul2.dnz_chr_id = p_khr_id

Line 6083: okc_rules_b rul2,

6079: TO_NUMBER(NULL) residual_value,
6080: NULL fee_type
6081: FROM okc_rule_groups_b rgp,
6082: okc_rules_b rul1,
6083: okc_rules_b rul2,
6084: okl_strm_type_b sty
6085: WHERE
6086: rul2.dnz_chr_id = p_khr_id
6087: AND rul2.rule_information_category = 'LASLL'

Line 6130: OKC_RULES_B sll,

6126:
6127: Cursor c_rollover_pmnts( chrId NUMBER, kleId NUMBER ) IS
6128: Select nvl(slh.object1_id1, -1) styId
6129: From OKC_RULE_GROUPS_B rgp,
6130: OKC_RULES_B sll,
6131: okc_rules_b slh,
6132: okl_strm_type_b sty
6133: Where slh.rgp_id = rgp.id
6134: and rgp.RGD_CODE = 'LALEVL'

Line 6131: okc_rules_b slh,

6127: Cursor c_rollover_pmnts( chrId NUMBER, kleId NUMBER ) IS
6128: Select nvl(slh.object1_id1, -1) styId
6129: From OKC_RULE_GROUPS_B rgp,
6130: OKC_RULES_B sll,
6131: okc_rules_b slh,
6132: okl_strm_type_b sty
6133: Where slh.rgp_id = rgp.id
6134: and rgp.RGD_CODE = 'LALEVL'
6135: and sll.RULE_INFORMATION_CATEGORY = 'LASLL'

Line 6149: OKC_RULES_B crl,

6145:
6146: Cursor c_link_pmnts( chrId NUMBER, kleId NUMBER ) IS
6147: Select nvl(slh.object1_id1, -1) styId
6148: From OKC_RULE_GROUPS_B crg,
6149: OKC_RULES_B crl,
6150: okc_rules_b slh,
6151: okc_K_lines_b cle_lnk,
6152: okl_K_lines kle_roll
6153: Where slh.rgp_id = crg.id

Line 6150: okc_rules_b slh,

6146: Cursor c_link_pmnts( chrId NUMBER, kleId NUMBER ) IS
6147: Select nvl(slh.object1_id1, -1) styId
6148: From OKC_RULE_GROUPS_B crg,
6149: OKC_RULES_B crl,
6150: okc_rules_b slh,
6151: okc_K_lines_b cle_lnk,
6152: okl_K_lines kle_roll
6153: Where slh.rgp_id = crg.id
6154: and crg.RGD_CODE = 'LALEVL'

Line 6289: FROM okc_rules_b slh,

6285:
6286:
6287: CURSOR c_rent_sty_id (finfeesId NUMBER) IS
6288: SELECT slh.object1_id1
6289: FROM okc_rules_b slh,
6290: okc_rule_groups_b rgp
6291: WHERE rgp.dnz_chr_id = p_khr_id
6292: AND rgp.cle_id = finfeesId
6293: AND rgp.rgd_code= 'LALEVL'

Line 7905: okc_rules_b rul1,

7901: NULL lty_code,
7902: TO_NUMBER(NULL) capital_amount,
7903: TO_NUMBER(NULL) residual_value
7904: FROM okc_rule_groups_b rgp,
7905: okc_rules_b rul1,
7906: okc_rules_b rul2,
7907: okl_strm_type_tl sty
7908: WHERE rul2.dnz_chr_id = khrid
7909: AND rul2.rule_information_category = 'LASLL'

Line 7906: okc_rules_b rul2,

7902: TO_NUMBER(NULL) capital_amount,
7903: TO_NUMBER(NULL) residual_value
7904: FROM okc_rule_groups_b rgp,
7905: okc_rules_b rul1,
7906: okc_rules_b rul2,
7907: okl_strm_type_tl sty
7908: WHERE rul2.dnz_chr_id = khrid
7909: AND rul2.rule_information_category = 'LASLL'
7910: AND rul2.rgp_id = rgp.id

Line 8319: OKC_RULES_B crl

8315:
8316: cursor l_hdrrl_csr IS
8317: select crl.RULE_INFORMATION1 method
8318: from OKC_RULE_GROUPS_B crg,
8319: OKC_RULES_B crl
8320: where crl.rgp_id = crg.id
8321: and crg.RGD_CODE = 'LASEIR'
8322: and crl.RULE_INFORMATION_CATEGORY = 'LASEIR'
8323: and crg.dnz_chr_id = p_agreement_id;

Line 8986: OKC_RULES_B crl

8982:
8983: cursor l_hdrrl_csr IS
8984: select crl.RULE_INFORMATION1 method
8985: from OKC_RULE_GROUPS_B crg,
8986: OKC_RULES_B crl
8987: where crl.rgp_id = crg.id
8988: and crg.RGD_CODE = 'LASEIR'
8989: and crl.RULE_INFORMATION_CATEGORY = 'LASEIR'
8990: and crg.dnz_chr_id = p_agreement_id;

Line 11011: FROM okc_rules_b sll,

11007: CURSOR c_inflows ( styId NUMBER) IS
11008: SELECT DISTINCT
11009: sll.object1_id1 frequency,
11010: nvl(sll.rule_information10, 'N') advance_arrears
11011: FROM okc_rules_b sll,
11012: okc_rules_b slh,
11013: okc_rule_groups_b rgp
11014: WHERE rgp.rgd_code = 'LALEVL'
11015: AND rgp.id = slh.rgp_id

Line 11012: okc_rules_b slh,

11008: SELECT DISTINCT
11009: sll.object1_id1 frequency,
11010: nvl(sll.rule_information10, 'N') advance_arrears
11011: FROM okc_rules_b sll,
11012: okc_rules_b slh,
11013: okc_rule_groups_b rgp
11014: WHERE rgp.rgd_code = 'LALEVL'
11015: AND rgp.id = slh.rgp_id
11016: AND slh.rule_information_category = 'LASLH'

Line 11056: FROM okc_rules_b sll,

11052: l_sty_id NUMBER;
11053:
11054: cursor fee_strm_type_csr is
11055: SELECT sty.id
11056: FROM okc_rules_b sll,
11057: okc_rules_b slh,
11058: okc_rule_groups_b rgp,
11059: okl_strm_type_b sty
11060: WHERE rgp.dnz_chr_id = p_khr_id

Line 11057: okc_rules_b slh,

11053:
11054: cursor fee_strm_type_csr is
11055: SELECT sty.id
11056: FROM okc_rules_b sll,
11057: okc_rules_b slh,
11058: okc_rule_groups_b rgp,
11059: okl_strm_type_b sty
11060: WHERE rgp.dnz_chr_id = p_khr_id
11061: AND rgp.cle_id = p_kle_id

Line 11336: okc_rules_b rul1,

11332: NULL lty_code,
11333: TO_NUMBER(NULL) capital_amount,
11334: TO_NUMBER(NULL) residual_value
11335: FROM okc_rule_groups_b rgp,
11336: okc_rules_b rul1,
11337: okc_rules_b rul2,
11338: okl_strm_type_b sty
11339: WHERE rul2.dnz_chr_id = khrid
11340: AND rul2.rule_information_category = 'LASLL'

Line 11337: okc_rules_b rul2,

11333: TO_NUMBER(NULL) capital_amount,
11334: TO_NUMBER(NULL) residual_value
11335: FROM okc_rule_groups_b rgp,
11336: okc_rules_b rul1,
11337: okc_rules_b rul2,
11338: okl_strm_type_b sty
11339: WHERE rul2.dnz_chr_id = khrid
11340: AND rul2.rule_information_category = 'LASLL'
11341: AND rul2.rgp_id = rgp.id

Line 11610: okc_rules_b rul1,

11606: kle.capital_amount capital_amount,
11607: kle.residual_value residual_value,
11608: kle.fee_type fee_type
11609: FROM okc_rule_groups_b rgp,
11610: okc_rules_b rul1,
11611: okc_rules_b rul2,
11612: okc_k_lines_b cle,
11613: okl_k_lines kle,
11614: okc_line_styles_b lse

Line 11611: okc_rules_b rul2,

11607: kle.residual_value residual_value,
11608: kle.fee_type fee_type
11609: FROM okc_rule_groups_b rgp,
11610: okc_rules_b rul1,
11611: okc_rules_b rul2,
11612: okc_k_lines_b cle,
11613: okl_k_lines kle,
11614: okc_line_styles_b lse
11615: WHERE

Line 11840: okc_rules_b rul1,

11836: kle.capital_amount capital_amount,
11837: kle.residual_value residual_value,
11838: kle.fee_type fee_type
11839: FROM okc_rule_groups_b rgp,
11840: okc_rules_b rul1,
11841: okc_rules_b rul2,
11842: okc_k_lines_b cle,
11843: okl_k_lines kle,
11844: okc_line_styles_b lse,

Line 11841: okc_rules_b rul2,

11837: kle.residual_value residual_value,
11838: kle.fee_type fee_type
11839: FROM okc_rule_groups_b rgp,
11840: okc_rules_b rul1,
11841: okc_rules_b rul2,
11842: okc_k_lines_b cle,
11843: okl_k_lines kle,
11844: okc_line_styles_b lse,
11845: okl_strm_type_b sty