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

Line 1099: okc_rule_groups_b rgpb,

1095: rulb2.RULE_INFORMATION7 stub_days,
1096: rulb2.RULE_INFORMATION8 stub_amount,
1097: rulb2.RULE_INFORMATION10 arrear_yn
1098: FROM okc_k_lines_b cleb,
1099: okc_rule_groups_b rgpb,
1100: okc_rules_b rulb,
1101: okc_rules_b rulb2,
1102: okl_strm_type_b styb
1103: WHERE rgpb.chr_id IS NULL

Line 1375: rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,

1371: l_base_rate_defined BOOLEAN := FALSE;
1372: l_var_int_schedule_defined BOOLEAN := FALSE;
1373:
1374: CURSOR l_pmnt_strm_hdr(
1375: rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
1376: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
1377: chrId NUMBER) IS
1378: SELECT crg.cle_id,
1379: crl.id,

Line 1390: FROM OKC_RULE_GROUPS_B crg,

1386: crl.RULE_INFORMATION5,
1387: crl.RULE_INFORMATION6,
1388: crl.RULE_INFORMATION10,
1389: crl.RULE_INFORMATION11
1390: FROM OKC_RULE_GROUPS_B crg,
1391: OKC_RULES_B crl,
1392: OKL_STRM_TYPE_B stty
1393: WHERE stty.id = crl.object1_id1
1394: AND stty.stream_type_purpose IN (

Line 1406: rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,

1402:
1403: l_pmnt_strm_hdr_rec l_pmnt_strm_hdr%ROWTYPE;
1404:
1405: CURSOR l_pmnt_strm_check(
1406: rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
1407: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
1408: pmnt_strm_purpose OKL_STRM_TYPE_B.STREAM_TYPE_PURPOSE%TYPE,
1409: chrId NUMBER) IS
1410: SELECT crg.cle_id,

Line 1421: FROM OKC_RULE_GROUPS_B crg,

1417: crl.RULE_INFORMATION5,
1418: crl.RULE_INFORMATION6,
1419: crl.RULE_INFORMATION10,
1420: crl.RULE_INFORMATION11
1421: FROM OKC_RULE_GROUPS_B crg,
1422: OKC_RULES_B crl,
1423: OKL_STRM_TYPE_B stty
1424: WHERE stty.id = crl.object1_id1
1425: AND stty.stream_type_purpose = pmnt_strm_purpose

Line 1432: rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,

1428: AND crl.RULE_INFORMATION_CATEGORY = rlcat
1429: AND crg.dnz_chr_id = chrId;
1430:
1431: CURSOR l_pmnt_strm_check2(
1432: rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
1433: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
1434: pmnt_strm_purpose OKL_STRM_TYPE_B.STREAM_TYPE_PURPOSE%TYPE,
1435: chrId NUMBER) IS
1436: SELECT crg.cle_id,

Line 1447: FROM OKC_RULE_GROUPS_B crg,

1443: crl.RULE_INFORMATION5,
1444: crl.RULE_INFORMATION6,
1445: crl.RULE_INFORMATION10,
1446: crl.RULE_INFORMATION11
1447: FROM OKC_RULE_GROUPS_B crg,
1448: OKC_RULES_B crl,
1449: OKL_STRM_TYPE_B stty
1450: WHERE stty.id = crl.object1_id1
1451: AND stty.stream_type_purpose = pmnt_strm_purpose

Line 1517: OKC_RULE_GROUPS_B RGP

1513:
1514: CURSOR rate_delay_csr(p_id NUMBER) IS
1515: SELECT TO_NUMBER(RULE_INFORMATION3)
1516: FROM OKC_RULES_B RULE,
1517: OKC_RULE_GROUPS_B RGP
1518: WHERE RGP.ID = RULE.RGP_ID
1519: AND RGP.DNZ_CHR_ID = p_id
1520: AND RGD_CODE = 'LABILL'
1521: AND RULE_INFORMATION_CATEGORY = 'LAINVD';

Line 2473: CURSOR l_pmnt_strm_check(rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,

2469: calc_meth VARCHAR2(256);
2470: l_deal_type VARCHAR2(256);
2471:
2472: --Bug#3931587
2473: CURSOR l_pmnt_strm_check(rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
2474: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
2475: --pmnt_strm_name OKL_STRMTYP_SOURCE_V.NAME%TYPE,
2476: pmnt_strm_purpose OKL_STRM_TYPE_B.STREAM_TYPE_PURPOSE%TYPE,
2477: chrId NUMBER) IS

Line 2489: FROM OKC_RULE_GROUPS_B crg,

2485: crl.RULE_INFORMATION5,
2486: crl.RULE_INFORMATION6,
2487: crl.RULE_INFORMATION10,
2488: crl.RULE_INFORMATION11
2489: FROM OKC_RULE_GROUPS_B crg,
2490: OKC_RULES_B crl,
2491: OKL_STRM_TYPE_B stty
2492: WHERE stty.id = crl.object1_id1
2493: --and stty.code = pmnt_strm_name

Line 3192: okc_rule_groups_b rgp

3188: TO_NUMBER(sll.rule_information7) - 1) end_date,
3189: TO_NUMBER(sll.rule_information6) amount
3190: FROM okc_rules_b sll,
3191: okc_rules_b slh,
3192: okc_rule_groups_b rgp
3193: WHERE rgp.dnz_chr_id = p_chr_id
3194: AND rgp.cle_id = p_cle_id
3195: AND rgp.rgd_code = 'LALEVL'
3196: AND slh.rgp_id = rgp.id

Line 3310: okc_rule_groups_b rgp,

3306: style.name line_style
3307: FROM okl_k_lines_full_v line,
3308: okc_line_styles_v style,
3309: okc_statuses_v sts,
3310: okc_rule_groups_b rgp,
3311: okc_rules_b rule
3312: WHERE rgp.id = rule.rgp_id
3313: AND line.id = rgp.cle_id
3314: AND line.lse_id = style.id

Line 3851: CURSOR l_assetrl_csr( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,

3847: AND kle.dnz_chr_id = chrid
3848: AND sts.code = kle.sts_code
3849: AND sts.ste_code NOT IN ( 'HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED');
3850:
3851: CURSOR l_assetrl_csr( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
3852: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
3853: chrId NUMBER,
3854: cleId NUMBER) IS
3855: SELECT crl.RULE_INFORMATION1,

Line 3857: FROM OKC_RULE_GROUPS_B crg,

3853: chrId NUMBER,
3854: cleId NUMBER) IS
3855: SELECT crl.RULE_INFORMATION1,
3856: crl.RULE_INFORMATION3
3857: FROM OKC_RULE_GROUPS_B crg,
3858: OKC_RULES_B crl
3859: WHERE crl.rgp_id = crg.id
3860: AND crg.RGD_CODE = rgcode
3861: AND crl.RULE_INFORMATION_CATEGORY = rlcat

Line 3865: CURSOR l_strm_asset_csr(rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,

3861: AND crl.RULE_INFORMATION_CATEGORY = rlcat
3862: AND crg.dnz_chr_id = chrId
3863: AND crg.cle_id = cleId;
3864:
3865: CURSOR l_strm_asset_csr(rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
3866: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
3867: pmnt_strm_purpose OKL_STRM_TYPE_B.STREAM_TYPE_PURPOSE%TYPE,
3868: chrId NUMBER,
3869: cleId NUMBER) IS

Line 3872: FROM OKC_RULE_GROUPS_B crg,

3868: chrId NUMBER,
3869: cleId NUMBER) IS
3870: SELECT crl.id,
3871: crl.object1_id1
3872: FROM OKC_RULE_GROUPS_B crg,
3873: OKC_RULES_B crl,
3874: OKL_STRM_TYPE_B stty
3875: WHERE stty.id = TO_NUMBER(crl.object1_id1)
3876: AND stty.stream_type_purpose = pmnt_strm_purpose

Line 3885: FROM okc_rule_groups_b rgp,

3881: AND crg.dnz_chr_id = chrId;
3882:
3883: CURSOR est_head_csr (p_chr_id NUMBER) IS
3884: SELECT 'Y'
3885: FROM okc_rule_groups_b rgp,
3886: okc_rules_b rule,
3887: okl_strm_type_b stty
3888: WHERE rgp.id = rule.rgp_id
3889: AND stty.id = TO_NUMBER(rule.object1_id1)

Line 4058: okc_rule_groups_b rgp

4054: SELECT
4055: 'Y' only_stub,
4056: rule.object2_id1
4057: FROM okc_rules_b rule,
4058: okc_rule_groups_b rgp
4059: WHERE rgp.id = rule.rgp_id
4060: AND rgp.rgd_code = 'LALEVL'
4061: AND rgp.chr_id = p_chr_id
4062: AND rgp.dnz_chr_id = rgp.chr_id

Line 4080: okc_rule_groups_b rgp,

4076: style.name,
4077: rule.object2_id1,
4078: 'Y' stub_only
4079: FROM okc_rules_b rule,
4080: okc_rule_groups_b rgp,
4081: okc_k_lines_b line,
4082: okc_line_styles_v style,
4083: okc_statuses_b sts
4084: WHERE rgp.id = rule.rgp_id

Line 4774: okc_rule_groups_b rgp

4770: AND to_number(SLH.OBJECT1_ID1) = STY.ID ) STREAM_TYPE
4771: --styt.name stream_type
4772: FROM okc_rules_b sll,
4773: okc_rules_b slh,
4774: okc_rule_groups_b rgp
4775: --okl_strm_type_b sty,
4776: --okl_strm_type_tl styt
4777: WHERE rgp.dnz_chr_id = p_khr_id
4778: AND rgp.cle_id = p_kle_id

Line 4799: okc_rule_groups_b rgp,

4795: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) mpp,
4796: styt.name stream_type
4797: FROM okc_rules_b sll,
4798: okc_rules_b slh,
4799: okc_rule_groups_b rgp,
4800: okl_strm_type_b sty,
4801: okl_strm_type_tl styt
4802: WHERE rgp.dnz_chr_id = p_khr_id
4803: AND rgp.cle_id = p_kle_id

Line 4825: okc_rule_groups_b rgp

4821: AND to_number(RULE.OBJECT1_ID1) = STY.ID ) STREAM_TYPE,
4822: rule.id rule_id,
4823: rgp.id rgp_id
4824: FROM okc_rules_b rule,
4825: okc_rule_groups_b rgp
4826: --okl_strm_type_b sty, Bug 4929573
4827: --okl_strm_type_tl styt
4828: WHERE rgp.cle_id = p_kle_id
4829: AND rgp.dnz_chr_id = p_khr_id

Line 4838: p_rgp_id OKC_RULE_GROUPS_B.ID%TYPE) IS

4834: --AND styt.LANGUAGE = USERENV('LANG')
4835: --AND sty.id = styt.id;
4836:
4837: CURSOR c_strm_sll_ext (p_rule_id OKC_RULES_B.ID%TYPE,
4838: p_rgp_id OKC_RULE_GROUPS_B.ID%TYPE) IS
4839: SELECT sll.rule_information2 start_date,
4840: sll.rule_information3 periods,
4841: sll.rule_information7 stub_day,
4842: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) mpp

Line 4875: okc_rule_groups_b rgp,

4871: p_kle_id OKC_K_LINES_B.ID%TYPE) IS
4872: SELECT COUNT(sll.id)
4873: FROM okc_rules_b sll,
4874: okc_rules_b slh,
4875: okc_rule_groups_b rgp,
4876: okl_strm_type_b sty,
4877: okl_strm_type_tl styt
4878: WHERE rgp.dnz_chr_id = p_khr_id
4879: AND rgp.cle_id = p_kle_id

Line 4890: p_rgp_id OKC_RULE_GROUPS_B.ID%TYPE) IS

4886: AND TO_CHAR(slh.id) = sll.object2_id1
4887: AND sll.rule_information_category = 'LASLL'; --| 17-Jan-06 cklee Fixed bug#4956483 |
4888:
4889: CURSOR c_strm_sll_ext_count (p_rule_id OKC_RULES_B.ID%TYPE,
4890: p_rgp_id OKC_RULE_GROUPS_B.ID%TYPE) IS
4891: SELECT COUNT(sll.id)
4892: FROM okc_rules_b sll
4893: WHERE sll.rgp_id = p_rgp_id
4894: AND sll.object2_id1 = TO_CHAR(p_rule_id)

Line 5836: okc_rule_groups_b rgp,

5832: TO_NUMBER(SLL.rule_information3)*DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12)) - 1) end_date,
5833: styt.name stream_type
5834: FROM okc_rules_b sll,
5835: okc_rules_b slh,
5836: okc_rule_groups_b rgp,
5837: okl_strm_type_b sty,
5838: okl_strm_type_tl styt
5839: WHERE rgp.dnz_chr_id = chrID
5840: AND rgp.cle_id = feeLine

Line 5859: okc_rule_groups_b rgp,

5855: feeLine IN OKL_K_LINES.ID%TYPE) IS
5856:
5857: SELECT slh.id
5858: FROM okc_rules_b slh,
5859: okc_rule_groups_b rgp,
5860: okl_strm_type_b sty,
5861: okl_strm_type_tl styt
5862: WHERE rgp.dnz_chr_id = chrID
5863: AND rgp.cle_id = feeLine

Line 6279: okc_rule_groups_b rgp,

6275: TO_NUMBER(SLL.rule_information3)*DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12)) - 1) end_date,
6276: styt.name stream_type
6277: FROM okc_rules_b sll,
6278: okc_rules_b slh,
6279: okc_rule_groups_b rgp,
6280: okl_strm_type_b sty,
6281: okl_strm_type_tl styt
6282: WHERE rgp.dnz_chr_id = chrID
6283: AND rgp.cle_id = feeLine

Line 6302: okc_rule_groups_b rgp,

6298: feeLine IN OKL_K_LINES.ID%TYPE) IS
6299:
6300: SELECT slh.id
6301: FROM okc_rules_b slh,
6302: okc_rule_groups_b rgp,
6303: okl_strm_type_b sty,
6304: okl_strm_type_tl styt
6305: WHERE rgp.dnz_chr_id = chrID
6306: AND rgp.cle_id = feeLine

Line 6984: FROM OKC_RULE_GROUPS_B rgp,

6980: and deal_type = 'LOAN';
6981:
6982: CURSOR get_payment_lns (p_chr_id IN NUMBER) IS
6983: SELECT rgp.id,rgp.cle_id
6984: FROM OKC_RULE_GROUPS_B rgp,
6985: OKC_RULES_B crl2,
6986: okc_k_lines_b cleb,
6987: OKL_STRM_TYPE_B stty
6988: WHERE stty.id = crl2.object1_id1

Line 7414: FROM OKC_RULE_GROUPS_B crg,

7410: SELECT crg.cle_id,
7411: crl.id,
7412: crl.object1_id1,
7413: crl.RULE_INFORMATION6
7414: FROM OKC_RULE_GROUPS_B crg,
7415: OKC_RULES_B crl,
7416: OKL_STRM_TYPE_B stty
7417: WHERE stty.id = crl.object1_id1
7418: AND stty.stream_type_purpose = 'DOWN_PAYMENT'

Line 7432: FROM OKC_RULES_B crl1, OKC_RULES_B crl2, OKC_RULE_GROUPS_B rgp

7428: crl2.object1_id2,
7429: crl2.rule_information2,
7430: NVL(crl2.rule_information3,0) rule_information3,
7431: NVL(crl2.rule_information6,0) rule_information6
7432: FROM OKC_RULES_B crl1, OKC_RULES_B crl2, OKC_RULE_GROUPS_B rgp
7433: WHERE crl1.id = crl2.object2_id1
7434: AND crl1.id = p_id
7435: AND rgp.cle_id = p_cle_id
7436: AND rgp.id = crl1.rgp_id

Line 9133: CURSOR l_rl_csr( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,

9129: *
9130: * l_synd_rec l_synd_csr%ROWTYPE;
9131: *
9132: */
9133: CURSOR l_rl_csr( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
9134: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
9135: chrId OKC_RULE_GROUPS_B.DNZ_CHR_ID%TYPE ) IS
9136: SELECT crl.RULE_INFORMATION1, crl.RULE_INFORMATION2
9137: FROM OKC_RULE_GROUPS_B crg, OKC_RULES_B crl

Line 9135: chrId OKC_RULE_GROUPS_B.DNZ_CHR_ID%TYPE ) IS

9131: *
9132: */
9133: CURSOR l_rl_csr( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
9134: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
9135: chrId OKC_RULE_GROUPS_B.DNZ_CHR_ID%TYPE ) IS
9136: SELECT crl.RULE_INFORMATION1, crl.RULE_INFORMATION2
9137: FROM OKC_RULE_GROUPS_B crg, OKC_RULES_B crl
9138: WHERE crl.rgp_id = crg.id
9139: AND crg.RGD_CODE = rgcode

Line 9137: FROM OKC_RULE_GROUPS_B crg, OKC_RULES_B crl

9133: CURSOR l_rl_csr( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
9134: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
9135: chrId OKC_RULE_GROUPS_B.DNZ_CHR_ID%TYPE ) IS
9136: SELECT crl.RULE_INFORMATION1, crl.RULE_INFORMATION2
9137: FROM OKC_RULE_GROUPS_B crg, OKC_RULES_B crl
9138: WHERE crl.rgp_id = crg.id
9139: AND crg.RGD_CODE = rgcode
9140: AND crl.RULE_INFORMATION_CATEGORY = rlcat
9141: AND crg.dnz_chr_id = chrId;

Line 9958: CURSOR l_rl_csr( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,

9954: l_count NUMBER := 0;
9955: l_row_notfound BOOLEAN;
9956: l_token VARCHAR2(2000);
9957:
9958: CURSOR l_rl_csr( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
9959: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
9960: chrid OKC_RULE_GROUPS_B.DNZ_CHR_ID%TYPE ) IS
9961: SELECT crl.RULE_INFORMATION1, crl.RULE_INFORMATION2
9962: FROM OKC_RULE_GROUPS_B crg, OKC_RULES_B crl

Line 9960: chrid OKC_RULE_GROUPS_B.DNZ_CHR_ID%TYPE ) IS

9956: l_token VARCHAR2(2000);
9957:
9958: CURSOR l_rl_csr( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
9959: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
9960: chrid OKC_RULE_GROUPS_B.DNZ_CHR_ID%TYPE ) IS
9961: SELECT crl.RULE_INFORMATION1, crl.RULE_INFORMATION2
9962: FROM OKC_RULE_GROUPS_B crg, OKC_RULES_B crl
9963: WHERE crl.rgp_id = crg.id
9964: AND crg.RGD_CODE = rgcode

Line 9962: FROM OKC_RULE_GROUPS_B crg, OKC_RULES_B crl

9958: CURSOR l_rl_csr( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
9959: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
9960: chrid OKC_RULE_GROUPS_B.DNZ_CHR_ID%TYPE ) IS
9961: SELECT crl.RULE_INFORMATION1, crl.RULE_INFORMATION2
9962: FROM OKC_RULE_GROUPS_B crg, OKC_RULES_B crl
9963: WHERE crl.rgp_id = crg.id
9964: AND crg.RGD_CODE = rgcode
9965: AND crl.RULE_INFORMATION_CATEGORY = rlcat
9966: AND crg.dnz_chr_id = chrid;

Line 10771: okc_rule_groups_b rgp,

10767: CURSOR pmnt_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE,
10768: p_line_type OKC_LINE_STYLES_B.LTY_CODE%TYPE) IS
10769: SELECT COUNT(1)
10770: FROM okc_rules_b rule,
10771: okc_rule_groups_b rgp,
10772: okc_k_lines_b line,
10773: okc_line_styles_b style,
10774: okl_strm_type_b strm
10775: WHERE rgp.dnz_chr_id = p_chr_id

Line 11027: CURSOR tax_rule_csr (rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,

11023: AND style.lty_code = 'FREE_FORM1'
11024: AND line.sts_code = sts.code
11025: AND sts.ste_code NOT IN ( 'HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED');
11026:
11027: CURSOR tax_rule_csr (rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
11028: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
11029: chrId NUMBER,
11030: cleId NUMBER) IS
11031: SELECT crl.id slh_id,

Line 11041: FROM OKC_RULE_GROUPS_B crg,

11037: crl.RULE_INFORMATION5,
11038: crl.RULE_INFORMATION6,
11039: crl.RULE_INFORMATION7,
11040: crl.RULE_INFORMATION10
11041: FROM OKC_RULE_GROUPS_B crg,
11042: OKC_RULES_B crl
11043: WHERE crl.rgp_id = crg.id
11044: AND crg.RGD_CODE = rgcode
11045: AND crl.RULE_INFORMATION_CATEGORY = rlcat

Line 11573: okc_rule_groups_b rgp

11569: --Bug#3877032
11570: CURSOR l_invoice_format_csr IS
11571: SELECT rule.rule_information1
11572: FROM okc_rules_b rule,
11573: okc_rule_groups_b rgp
11574: WHERE rule.rgp_id = rgp.id
11575: AND rgp.dnz_chr_id = p_chr_id
11576: AND rgp.chr_id = p_chr_id
11577: AND rgp.rgd_code = 'LABILL'

Line 11835: okc_rule_groups_b rgp,

11831: SELECT styt.name stream_type,
11832: rule.id rule_id,
11833: rgp.id rgp_id
11834: FROM okc_rules_b rule,
11835: okc_rule_groups_b rgp,
11836: okl_strm_type_b sty,
11837: okl_strm_type_tl styt
11838: WHERE NVL(rgp.cle_id, -1) = p_kle_id
11839: AND rgp.dnz_chr_id = p_khr_id

Line 11848: p_rgp_id OKC_RULE_GROUPS_B.ID%TYPE) IS

11844: AND styt.LANGUAGE = USERENV('LANG')
11845: AND sty.id = styt.id;
11846:
11847: CURSOR l_strm_sll_csr (p_rule_id OKC_RULES_B.ID%TYPE,
11848: p_rgp_id OKC_RULE_GROUPS_B.ID%TYPE) IS
11849: SELECT Fnd_Date.canonical_to_date(sll.rule_information2) start_date,
11850: sll.rule_information1 seq,
11851: sll.rule_information6 amt,
11852: sll.rule_information7 stub_day,