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_RULES_B

Line 38: l_eg_eligible OKC_RULES_B.RULE_INFORMATION1%TYPE;

34: x_return_status OUT NOCOPY VARCHAR2,
35: p_chr_id IN NUMBER
36: ) IS
37:
38: l_eg_eligible OKC_RULES_B.RULE_INFORMATION1%TYPE;
39:
40: --Cursor to get the deal type of the contract
41: CURSOR deal_type_csr (p_chr_id IN NUMBER) IS
42: SELECT DEAL_TYPE

Line 49: FROM OKC_RULES_B

45:
46: --Cursor to get the Evergreen eligible flag
47: CURSOR eligible_csr (p_chr_id IN NUMBER) IS
48: SELECT RULE_INFORMATION1
49: FROM OKC_RULES_B
50: WHERE RULE_INFORMATION_CATEGORY = 'LAEVEL'
51: AND DNZ_CHR_ID = p_chr_id;
52:
53: l_deal_type OKL_K_HEADERS.DEAL_TYPE%TYPE;

Line 120: l_eg_eligible OKC_RULES_B.RULE_INFORMATION1%TYPE;

116: x_return_status OUT NOCOPY VARCHAR2,
117: p_chr_id IN NUMBER
118: ) IS
119:
120: l_eg_eligible OKC_RULES_B.RULE_INFORMATION1%TYPE;
121: l_eg_passthru_vendor OKC_RULES_B.OBJECT1_ID1%TYPE;
122: l_eg_passthru_vendor_site OKC_RULES_B.OBJECT2_ID1%TYPE;
123:
124: --Cursor to get the Evergreen eligible flag

Line 121: l_eg_passthru_vendor OKC_RULES_B.OBJECT1_ID1%TYPE;

117: p_chr_id IN NUMBER
118: ) IS
119:
120: l_eg_eligible OKC_RULES_B.RULE_INFORMATION1%TYPE;
121: l_eg_passthru_vendor OKC_RULES_B.OBJECT1_ID1%TYPE;
122: l_eg_passthru_vendor_site OKC_RULES_B.OBJECT2_ID1%TYPE;
123:
124: --Cursor to get the Evergreen eligible flag
125: CURSOR eligible_csr (p_chr_id IN NUMBER) IS

Line 122: l_eg_passthru_vendor_site OKC_RULES_B.OBJECT2_ID1%TYPE;

118: ) IS
119:
120: l_eg_eligible OKC_RULES_B.RULE_INFORMATION1%TYPE;
121: l_eg_passthru_vendor OKC_RULES_B.OBJECT1_ID1%TYPE;
122: l_eg_passthru_vendor_site OKC_RULES_B.OBJECT2_ID1%TYPE;
123:
124: --Cursor to get the Evergreen eligible flag
125: CURSOR eligible_csr (p_chr_id IN NUMBER) IS
126: SELECT RULE_INFORMATION1

Line 127: FROM OKC_RULES_B

123:
124: --Cursor to get the Evergreen eligible flag
125: CURSOR eligible_csr (p_chr_id IN NUMBER) IS
126: SELECT RULE_INFORMATION1
127: FROM OKC_RULES_B
128: WHERE RULE_INFORMATION_CATEGORY = 'LAEVEL'
129: AND DNZ_CHR_ID = p_chr_id;
130:
131: --Cursor to get the values of Evergreen Passthrough Vendor and Evergreen Passthrough Vendor Site

Line 134: FROM OKC_RULES_B

130:
131: --Cursor to get the values of Evergreen Passthrough Vendor and Evergreen Passthrough Vendor Site
132: CURSOR evergreen_passthru_csr (p_chr_id IN NUMBER) IS
133: SELECT OBJECT1_ID1,OBJECT2_ID1
134: FROM OKC_RULES_B
135: WHERE RULE_INFORMATION_CATEGORY = 'LAEVPT'
136: AND DNZ_CHR_ID = p_chr_id;
137:
138: --Cursor to get the deal type of the contract

Line 1080: okc_rules_b rulb,

1076: rulb2.RULE_INFORMATION8 stub_amount,
1077: rulb2.RULE_INFORMATION10 arrear_yn
1078: FROM okc_k_lines_b cleb,
1079: okc_rule_groups_b rgpb,
1080: okc_rules_b rulb,
1081: okc_rules_b rulb2,
1082: okl_strm_type_b styb
1083: WHERE rgpb.chr_id IS NULL
1084: AND rgpb.dnz_chr_id = cleb.dnz_chr_id

Line 1081: okc_rules_b rulb2,

1077: rulb2.RULE_INFORMATION10 arrear_yn
1078: FROM okc_k_lines_b cleb,
1079: okc_rule_groups_b rgpb,
1080: okc_rules_b rulb,
1081: okc_rules_b rulb2,
1082: okl_strm_type_b styb
1083: WHERE rgpb.chr_id IS NULL
1084: AND rgpb.dnz_chr_id = cleb.dnz_chr_id
1085: AND rgpb.cle_id = cleb.id

Line 1365: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,

1361:
1362: --Added OKL_STRM_TYPE_V and stty.name by bkatraga for bug 13478101
1363: CURSOR l_pmnt_strm_hdr(
1364: rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
1365: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
1366: chrId NUMBER) IS
1367: SELECT crg.cle_id,
1368: crl.id,
1369: stty.stream_type_purpose,

Line 1381: OKC_RULES_B crl,

1377: crl.RULE_INFORMATION10,
1378: crl.RULE_INFORMATION11,
1379: stty.name
1380: FROM OKC_RULE_GROUPS_B crg,
1381: OKC_RULES_B crl,
1382: OKL_STRM_TYPE_V stty
1383: WHERE stty.id = crl.object1_id1
1384: AND stty.stream_type_purpose IN (
1385: 'RENT', 'PRINCIPAL_PAYMENT', 'VARIABLE_INTEREST_SCHEDULE',

Line 1397: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,

1393: l_pmnt_strm_hdr_rec l_pmnt_strm_hdr%ROWTYPE;
1394:
1395: CURSOR l_pmnt_strm_check(
1396: rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
1397: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
1398: pmnt_strm_purpose OKL_STRM_TYPE_B.STREAM_TYPE_PURPOSE%TYPE,
1399: chrId NUMBER) IS
1400: SELECT crg.cle_id,
1401: crl.id,

Line 1412: OKC_RULES_B crl,

1408: crl.RULE_INFORMATION6,
1409: crl.RULE_INFORMATION10,
1410: crl.RULE_INFORMATION11
1411: FROM OKC_RULE_GROUPS_B crg,
1412: OKC_RULES_B crl,
1413: OKL_STRM_TYPE_B stty
1414: WHERE stty.id = crl.object1_id1
1415: AND stty.stream_type_purpose = pmnt_strm_purpose
1416: AND crl.rgp_id = crg.id

Line 1423: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,

1419: AND crg.dnz_chr_id = chrId;
1420:
1421: CURSOR l_pmnt_strm_check2(
1422: rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
1423: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
1424: pmnt_strm_purpose OKL_STRM_TYPE_B.STREAM_TYPE_PURPOSE%TYPE,
1425: chrId NUMBER) IS
1426: SELECT crg.cle_id,
1427: crl.id,

Line 1438: OKC_RULES_B crl,

1434: crl.RULE_INFORMATION6,
1435: crl.RULE_INFORMATION10,
1436: crl.RULE_INFORMATION11
1437: FROM OKC_RULE_GROUPS_B crg,
1438: OKC_RULES_B crl,
1439: OKL_STRM_TYPE_B stty
1440: WHERE stty.id = crl.object1_id1
1441: AND stty.stream_type_purpose = pmnt_strm_purpose
1442: AND crl.rgp_id = crg.id

Line 1453: l_var_stub_days OKC_RULES_B.rule_information7%TYPE := NULL;

1449:
1450: --Added by bkatraga for bug 13478101
1451: l_pymnt_start_date DATE := NULL;
1452: l_start_day NUMBER := NULL;
1453: l_var_stub_days OKC_RULES_B.rule_information7%TYPE := NULL;
1454: l_frequency OKC_RULES_B.OBJECT1_ID1%TYPE;
1455: l_factor NUMBER := 0;
1456: l_pymnt_end_date DATE := NULL;
1457: l_rent_amt_zero BOOLEAN := FALSE;

Line 1454: l_frequency OKC_RULES_B.OBJECT1_ID1%TYPE;

1450: --Added by bkatraga for bug 13478101
1451: l_pymnt_start_date DATE := NULL;
1452: l_start_day NUMBER := NULL;
1453: l_var_stub_days OKC_RULES_B.rule_information7%TYPE := NULL;
1454: l_frequency OKC_RULES_B.OBJECT1_ID1%TYPE;
1455: l_factor NUMBER := 0;
1456: l_pymnt_end_date DATE := NULL;
1457: l_rent_amt_zero BOOLEAN := FALSE;
1458: l_rent_strm_name OKL_STRM_TYPE_V.NAME%TYPE;

Line 1469: CURSOR l_pmnt_lns_in_hdr(p_id OKC_RULES_B.ID%TYPE, chrId NUMBER) IS

1465: FROM OKL_K_RATE_PARAMS
1466: WHERE KHR_ID = p_khr_id;
1467: --end bkatraga
1468:
1469: CURSOR l_pmnt_lns_in_hdr(p_id OKC_RULES_B.ID%TYPE, chrId NUMBER) IS
1470: SELECT
1471: crl2.object1_id1,
1472: crl2.object1_id2,
1473: crl2.rule_information2,

Line 1481: FROM OKC_RULES_B crl1, OKC_RULES_B crl2

1477: crl2.rule_information6,
1478: crl2.rule_information7,
1479: crl2.rule_information8,
1480: crl2.rule_information10
1481: FROM OKC_RULES_B crl1, OKC_RULES_B crl2
1482: WHERE TO_CHAR(crl1.id) = crl2.object2_id1
1483: AND crl1.id = p_id
1484: AND crl2.RULE_INFORMATION_CATEGORY = 'LASLL'
1485: AND crl1.RULE_INFORMATION_CATEGORY = 'LASLH'

Line 1490: CURSOR l_pmnt_lns_in_hdr2(p_id OKC_RULES_B.ID%TYPE, chrId NUMBER) IS

1486: AND crl1.dnz_chr_id = chrId
1487: AND crl2.dnz_chr_id = chrId
1488: ORDER BY crl2.rule_information2 ASC;
1489:
1490: CURSOR l_pmnt_lns_in_hdr2(p_id OKC_RULES_B.ID%TYPE, chrId NUMBER) IS
1491: SELECT
1492: crl2.object1_id1,
1493: crl2.object1_id2,
1494: crl2.rule_information2,

Line 1502: FROM OKC_RULES_B crl1, OKC_RULES_B crl2

1498: crl2.rule_information6,
1499: crl2.rule_information7,
1500: crl2.rule_information8,
1501: crl2.rule_information10
1502: FROM OKC_RULES_B crl1, OKC_RULES_B crl2
1503: WHERE TO_CHAR(crl1.id) = crl2.object2_id1
1504: AND crl1.id = p_id
1505: AND crl2.RULE_INFORMATION_CATEGORY = 'LASLL'
1506: AND crl1.RULE_INFORMATION_CATEGORY = 'LASLH'

Line 1526: FROM OKC_RULES_B RULE,

1522: l_cust_print_lead_days NUMBER := null;
1523:
1524: CURSOR rate_delay_csr(p_id NUMBER) IS
1525: SELECT TO_NUMBER(RULE_INFORMATION3)
1526: FROM OKC_RULES_B RULE,
1527: OKC_RULE_GROUPS_B RGP
1528: WHERE RGP.ID = RULE.RGP_ID
1529: AND RGP.DNZ_CHR_ID = p_id
1530: AND RGD_CODE = 'LABILL'

Line 2631: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,

2627: l_deal_type VARCHAR2(256);
2628:
2629: --Bug#3931587
2630: CURSOR l_pmnt_strm_check(rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
2631: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
2632: --pmnt_strm_name OKL_STRMTYP_SOURCE_V.NAME%TYPE,
2633: pmnt_strm_purpose OKL_STRM_TYPE_B.STREAM_TYPE_PURPOSE%TYPE,
2634: chrId NUMBER) IS
2635: SELECT crg.cle_id,

Line 2647: OKC_RULES_B crl,

2643: crl.RULE_INFORMATION6,
2644: crl.RULE_INFORMATION10,
2645: crl.RULE_INFORMATION11
2646: FROM OKC_RULE_GROUPS_B crg,
2647: OKC_RULES_B crl,
2648: OKL_STRM_TYPE_B stty
2649: WHERE stty.id = crl.object1_id1
2650: --and stty.code = pmnt_strm_name
2651: AND stty.stream_type_purpose = pmnt_strm_purpose

Line 2657: CURSOR l_pmnt_lns_in_hdr(p_id OKC_RULES_B.ID%TYPE, chrId NUMBER) IS

2653: AND crg.RGD_CODE = rgcode
2654: AND crl.RULE_INFORMATION_CATEGORY = rlcat
2655: AND crg.dnz_chr_id = chrId;
2656: l_pmnt_strm_check_rec l_pmnt_strm_check%ROWTYPE;
2657: CURSOR l_pmnt_lns_in_hdr(p_id OKC_RULES_B.ID%TYPE, chrId NUMBER) IS
2658: SELECT
2659: crl2.object1_id1,
2660: crl2.object1_id2,
2661: crl2.rule_information2,

Line 2669: FROM OKC_RULES_B crl1, OKC_RULES_B crl2

2665: crl2.rule_information6,
2666: crl2.rule_information7,
2667: crl2.rule_information8,
2668: crl2.rule_information10
2669: FROM OKC_RULES_B crl1, OKC_RULES_B crl2
2670: WHERE crl1.id = crl2.object2_id1
2671: AND crl1.id = p_id
2672: AND crl2.RULE_INFORMATION_CATEGORY = 'LASLL'
2673: AND crl1.RULE_INFORMATION_CATEGORY = 'LASLH'

Line 3375: FROM okc_rules_b sll,

3371: DECODE(sll.object1_id1, 'M',1,'Q',3,'S',6,'A',12)) - 1),
3372: Fnd_Date.canonical_to_date(sll.rule_information2) +
3373: TO_NUMBER(sll.rule_information7) - 1) end_date,
3374: TO_NUMBER(sll.rule_information6) amount
3375: FROM okc_rules_b sll,
3376: okc_rules_b slh,
3377: okc_rule_groups_b rgp
3378: WHERE rgp.dnz_chr_id = p_chr_id
3379: AND rgp.cle_id = p_cle_id

Line 3376: okc_rules_b slh,

3372: Fnd_Date.canonical_to_date(sll.rule_information2) +
3373: TO_NUMBER(sll.rule_information7) - 1) end_date,
3374: TO_NUMBER(sll.rule_information6) amount
3375: FROM okc_rules_b sll,
3376: okc_rules_b slh,
3377: okc_rule_groups_b rgp
3378: WHERE rgp.dnz_chr_id = p_chr_id
3379: AND rgp.cle_id = p_cle_id
3380: AND rgp.rgd_code = 'LALEVL'

Line 3389: TYPE amt_type IS TABLE OF okc_rules_b.rule_information6%TYPE;

3385: AND sll.rgp_id = rgp.id
3386: AND NVL(sll.rule_information6,0) <> 0
3387: ORDER BY start_date, end_date;
3388:
3389: TYPE amt_type IS TABLE OF okc_rules_b.rule_information6%TYPE;
3390: pymnt_amt amt_type;
3391: TYPE sdate_type IS TABLE OF okc_rules_b.rule_information2%TYPE;
3392: start_date sdate_type;
3393: TYPE edate_type IS TABLE OF okc_rules_b.rule_information2%TYPE;

Line 3391: TYPE sdate_type IS TABLE OF okc_rules_b.rule_information2%TYPE;

3387: ORDER BY start_date, end_date;
3388:
3389: TYPE amt_type IS TABLE OF okc_rules_b.rule_information6%TYPE;
3390: pymnt_amt amt_type;
3391: TYPE sdate_type IS TABLE OF okc_rules_b.rule_information2%TYPE;
3392: start_date sdate_type;
3393: TYPE edate_type IS TABLE OF okc_rules_b.rule_information2%TYPE;
3394: end_date edate_type;
3395: l_payment_amt okc_rules_b.rule_information6%TYPE;

Line 3393: TYPE edate_type IS TABLE OF okc_rules_b.rule_information2%TYPE;

3389: TYPE amt_type IS TABLE OF okc_rules_b.rule_information6%TYPE;
3390: pymnt_amt amt_type;
3391: TYPE sdate_type IS TABLE OF okc_rules_b.rule_information2%TYPE;
3392: start_date sdate_type;
3393: TYPE edate_type IS TABLE OF okc_rules_b.rule_information2%TYPE;
3394: end_date edate_type;
3395: l_payment_amt okc_rules_b.rule_information6%TYPE;
3396:
3397: --3. Disb basis for all vendors should be same

Line 3395: l_payment_amt okc_rules_b.rule_information6%TYPE;

3391: TYPE sdate_type IS TABLE OF okc_rules_b.rule_information2%TYPE;
3392: start_date sdate_type;
3393: TYPE edate_type IS TABLE OF okc_rules_b.rule_information2%TYPE;
3394: end_date edate_type;
3395: l_payment_amt okc_rules_b.rule_information6%TYPE;
3396:
3397: --3. Disb basis for all vendors should be same
3398: CURSOR disb_basis_csr (p_chr_id IN NUMBER, p_cle_id IN NUMBER) IS
3399: SELECT ppy.disbursement_basis, po.vendor_name

Line 3496: okc_rules_b rule

3492: FROM okl_k_lines_full_v line,
3493: okc_line_styles_v style,
3494: okc_statuses_v sts,
3495: okc_rule_groups_b rgp,
3496: okc_rules_b rule
3497: WHERE rgp.id = rule.rgp_id
3498: AND line.id = rgp.cle_id
3499: AND line.lse_id = style.id
3500: AND line.sts_code = sts.code

Line 3514: okc_rules_b rul

3510: --Cursor to get the fee payment frequency
3511: CURSOR c_feepayment_freq(khrId NUMBER, cleId NUMBER) IS
3512: SELECT rul.object1_id1 frequency
3513: FROM okc_rule_groups_b rgp,
3514: okc_rules_b rul
3515: WHERE rgp.dnz_chr_id = khrId
3516: AND rgp.cle_id = cleId
3517: AND rgp.RGD_CODE = 'LALEVL'
3518: AND rgp.id = rul.rgp_id

Line 4174: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,

4170: AND sts.code = kle.sts_code
4171: AND sts.ste_code NOT IN ( 'HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED');
4172:
4173: CURSOR l_assetrl_csr( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
4174: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
4175: chrId NUMBER,
4176: cleId NUMBER) IS
4177: SELECT crl.RULE_INFORMATION1,
4178: crl.RULE_INFORMATION3

Line 4180: OKC_RULES_B crl

4176: cleId NUMBER) IS
4177: SELECT crl.RULE_INFORMATION1,
4178: crl.RULE_INFORMATION3
4179: FROM OKC_RULE_GROUPS_B crg,
4180: OKC_RULES_B crl
4181: WHERE crl.rgp_id = crg.id
4182: AND crg.RGD_CODE = rgcode
4183: AND crl.RULE_INFORMATION_CATEGORY = rlcat
4184: AND crg.dnz_chr_id = chrId

Line 4188: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,

4184: AND crg.dnz_chr_id = chrId
4185: AND crg.cle_id = cleId;
4186:
4187: CURSOR l_strm_asset_csr(rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
4188: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
4189: pmnt_strm_purpose OKL_STRM_TYPE_B.STREAM_TYPE_PURPOSE%TYPE,
4190: chrId NUMBER,
4191: cleId NUMBER) IS
4192: SELECT crl.id,

Line 4195: OKC_RULES_B crl,

4191: cleId NUMBER) IS
4192: SELECT crl.id,
4193: crl.object1_id1
4194: FROM OKC_RULE_GROUPS_B crg,
4195: OKC_RULES_B crl,
4196: OKL_STRM_TYPE_B stty
4197: WHERE stty.id = TO_NUMBER(crl.object1_id1)
4198: AND stty.stream_type_purpose = pmnt_strm_purpose
4199: AND crl.rgp_id = crg.id

Line 4208: okc_rules_b rule,

4204:
4205: CURSOR est_head_csr (p_chr_id NUMBER) IS
4206: SELECT 'Y'
4207: FROM okc_rule_groups_b rgp,
4208: okc_rules_b rule,
4209: okl_strm_type_b stty
4210: WHERE rgp.id = rule.rgp_id
4211: AND stty.id = TO_NUMBER(rule.object1_id1)
4212: AND rgp.rgd_code = 'LALEVL'

Line 4370: okc_rules_b rule

4366: CURSOR stream_csr (p_slh_id VARCHAR2) IS
4367: SELECT strm.stream_type_purpose
4368: --SELECT strm.name
4369: FROM okl_strm_type_v strm,
4370: okc_rules_b rule
4371: WHERE rule.id = p_slh_id
4372: AND rule.rule_information_category = 'LASLH'
4373: AND rule.object1_id1 = strm.id;
4374:

Line 4379: FROM okc_rules_b rule,

4375: CURSOR hdr_stub_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
4376: SELECT
4377: 'Y' only_stub,
4378: rule.object2_id1
4379: FROM okc_rules_b rule,
4380: okc_rule_groups_b rgp
4381: WHERE rgp.id = rule.rgp_id
4382: AND rgp.rgd_code = 'LALEVL'
4383: AND rgp.chr_id = p_chr_id

Line 4389: FROM okc_rules_b rule2

4385: AND rgp.cle_id IS NULL
4386: AND rule.rule_information7 IS NOT NULL
4387: AND NOT EXISTS (
4388: SELECT 'Y'
4389: FROM okc_rules_b rule2
4390: WHERE rule2.rule_information3 IS NOT NULL
4391: AND rule2.rgp_id = rgp.id
4392: AND rule2.object2_id1 = rule.object2_id1
4393: );

Line 4401: FROM okc_rules_b rule,

4397: SELECT style.lty_code,
4398: style.name,
4399: rule.object2_id1,
4400: 'Y' stub_only
4401: FROM okc_rules_b rule,
4402: okc_rule_groups_b rgp,
4403: okc_k_lines_b line,
4404: okc_line_styles_v style,
4405: okc_statuses_b sts

Line 4416: FROM okc_rules_b rule2

4412: AND sts.ste_code NOT IN ( 'HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED')
4413: AND rule.rule_information7 IS NOT NULL
4414: AND NOT EXISTS (
4415: SELECT 'Y'
4416: FROM okc_rules_b rule2
4417: WHERE rule2.rule_information3 IS NOT NULL
4418: AND rule2.rgp_id = rgp.id
4419: AND rule2.object2_id1 = rule.object2_id1
4420: );

Line 5159: FROM okc_rules_b sll,

5155: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) mpp,
5156: ( select STYT.NAME from OKL_STRM_TYPE_B STY ,OKL_STRM_TYPE_TL STYT where STY.ID = STYT.ID AND STYT.LANGUAGE = USERENV ( 'LANG' )
5157: AND to_number(SLH.OBJECT1_ID1) = STY.ID ) STREAM_TYPE
5158: --styt.name stream_type
5159: FROM okc_rules_b sll,
5160: okc_rules_b slh,
5161: okc_rule_groups_b rgp
5162: --okl_strm_type_b sty,
5163: --okl_strm_type_tl styt

Line 5160: okc_rules_b slh,

5156: ( select STYT.NAME from OKL_STRM_TYPE_B STY ,OKL_STRM_TYPE_TL STYT where STY.ID = STYT.ID AND STYT.LANGUAGE = USERENV ( 'LANG' )
5157: AND to_number(SLH.OBJECT1_ID1) = STY.ID ) STREAM_TYPE
5158: --styt.name stream_type
5159: FROM okc_rules_b sll,
5160: okc_rules_b slh,
5161: okc_rule_groups_b rgp
5162: --okl_strm_type_b sty,
5163: --okl_strm_type_tl styt
5164: WHERE rgp.dnz_chr_id = p_khr_id

Line 5184: FROM okc_rules_b sll,

5180: SELECT
5181: SUM(NVL(TO_NUMBER(SLL.rule_information3),0)) periods,
5182: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) mpp,
5183: styt.name stream_type
5184: FROM okc_rules_b sll,
5185: okc_rules_b slh,
5186: okc_rule_groups_b rgp,
5187: okl_strm_type_b sty,
5188: okl_strm_type_tl styt

Line 5185: okc_rules_b slh,

5181: SUM(NVL(TO_NUMBER(SLL.rule_information3),0)) periods,
5182: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) mpp,
5183: styt.name stream_type
5184: FROM okc_rules_b sll,
5185: okc_rules_b slh,
5186: okc_rule_groups_b rgp,
5187: okl_strm_type_b sty,
5188: okl_strm_type_tl styt
5189: WHERE rgp.dnz_chr_id = p_khr_id

Line 5211: FROM okc_rules_b rule,

5207: where STY.ID = STYT.ID AND STYT.LANGUAGE = USERENV ( 'LANG' )
5208: AND to_number(RULE.OBJECT1_ID1) = STY.ID ) STREAM_TYPE,
5209: rule.id rule_id,
5210: rgp.id rgp_id
5211: FROM okc_rules_b rule,
5212: okc_rule_groups_b rgp
5213: --okl_strm_type_b sty, Bug 4929573
5214: --okl_strm_type_tl styt
5215: WHERE rgp.cle_id = p_kle_id

Line 5224: CURSOR c_strm_sll_ext (p_rule_id OKC_RULES_B.ID%TYPE,

5220: --AND rule.object1_id1 = TO_CHAR(sty.id)
5221: --AND styt.LANGUAGE = USERENV('LANG')
5222: --AND sty.id = styt.id;
5223:
5224: CURSOR c_strm_sll_ext (p_rule_id OKC_RULES_B.ID%TYPE,
5225: p_rgp_id OKC_RULE_GROUPS_B.ID%TYPE) IS
5226: SELECT sll.rule_information2 start_date,
5227: sll.rule_information3 periods,
5228: sll.rule_information7 stub_day,

Line 5230: FROM okc_rules_b sll

5226: SELECT sll.rule_information2 start_date,
5227: sll.rule_information3 periods,
5228: sll.rule_information7 stub_day,
5229: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) mpp
5230: FROM okc_rules_b sll
5231: WHERE sll.rgp_id = p_rgp_id
5232: AND sll.object2_id1 = TO_CHAR(p_rule_id)
5233: AND sll.rule_information_category = 'LASLL'
5234: -- cklee/mvasudev,06-02-2005,Bug#4392051/okl.h 4437938

Line 5260: FROM okc_rules_b sll,

5256: -- START: cklee/mvasudev,06-02-2005,Bug#4392051/okl.h 4437938
5257: CURSOR c_strm_sll_count (p_khr_id OKC_K_HEADERS_B.ID%TYPE,
5258: p_kle_id OKC_K_LINES_B.ID%TYPE) IS
5259: SELECT COUNT(sll.id)
5260: FROM okc_rules_b sll,
5261: okc_rules_b slh,
5262: okc_rule_groups_b rgp,
5263: okl_strm_type_b sty,
5264: okl_strm_type_tl styt

Line 5261: okc_rules_b slh,

5257: CURSOR c_strm_sll_count (p_khr_id OKC_K_HEADERS_B.ID%TYPE,
5258: p_kle_id OKC_K_LINES_B.ID%TYPE) IS
5259: SELECT COUNT(sll.id)
5260: FROM okc_rules_b sll,
5261: okc_rules_b slh,
5262: okc_rule_groups_b rgp,
5263: okl_strm_type_b sty,
5264: okl_strm_type_tl styt
5265: WHERE rgp.dnz_chr_id = p_khr_id

Line 5276: CURSOR c_strm_sll_ext_count (p_rule_id OKC_RULES_B.ID%TYPE,

5272: AND sty.id = styt.id
5273: AND TO_CHAR(slh.id) = sll.object2_id1
5274: AND sll.rule_information_category = 'LASLL'; --| 17-Jan-06 cklee Fixed bug#4956483 |
5275:
5276: CURSOR c_strm_sll_ext_count (p_rule_id OKC_RULES_B.ID%TYPE,
5277: p_rgp_id OKC_RULE_GROUPS_B.ID%TYPE) IS
5278: SELECT COUNT(sll.id)
5279: FROM okc_rules_b sll
5280: WHERE sll.rgp_id = p_rgp_id

Line 5279: FROM okc_rules_b sll

5275:
5276: CURSOR c_strm_sll_ext_count (p_rule_id OKC_RULES_B.ID%TYPE,
5277: p_rgp_id OKC_RULE_GROUPS_B.ID%TYPE) IS
5278: SELECT COUNT(sll.id)
5279: FROM okc_rules_b sll
5280: WHERE sll.rgp_id = p_rgp_id
5281: AND sll.object2_id1 = TO_CHAR(p_rule_id)
5282: AND sll.rule_information_category = 'LASLL'; --| 17-Jan-06 cklee Fixed bug#4956483 |
5283:

Line 6221: FROM okc_rules_b sll,

6217: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) mpp,
6218: TRUNC(ADD_MONTHS(Fnd_Date.canonical_to_date(sll.rule_information2),
6219: TO_NUMBER(SLL.rule_information3)*DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12)) - 1) end_date,
6220: styt.name stream_type
6221: FROM okc_rules_b sll,
6222: okc_rules_b slh,
6223: okc_rule_groups_b rgp,
6224: okl_strm_type_b sty,
6225: okl_strm_type_tl styt

Line 6222: okc_rules_b slh,

6218: TRUNC(ADD_MONTHS(Fnd_Date.canonical_to_date(sll.rule_information2),
6219: TO_NUMBER(SLL.rule_information3)*DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12)) - 1) end_date,
6220: styt.name stream_type
6221: FROM okc_rules_b sll,
6222: okc_rules_b slh,
6223: okc_rule_groups_b rgp,
6224: okl_strm_type_b sty,
6225: okl_strm_type_tl styt
6226: WHERE rgp.dnz_chr_id = chrID

Line 6245: FROM okc_rules_b slh,

6241: CURSOR l_rq_fee_pmtH_csr ( chrID IN OKC_K_HEADERS_B.ID%TYPE,
6242: feeLine IN OKL_K_LINES.ID%TYPE) IS
6243:
6244: SELECT slh.id
6245: FROM okc_rules_b slh,
6246: okc_rule_groups_b rgp,
6247: okl_strm_type_b sty,
6248: okl_strm_type_tl styt
6249: WHERE rgp.dnz_chr_id = chrID

Line 6664: FROM okc_rules_b sll,

6660: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) mpp,
6661: TRUNC(ADD_MONTHS(Fnd_Date.canonical_to_date(sll.rule_information2),
6662: TO_NUMBER(SLL.rule_information3)*DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12)) - 1) end_date,
6663: styt.name stream_type
6664: FROM okc_rules_b sll,
6665: okc_rules_b slh,
6666: okc_rule_groups_b rgp,
6667: okl_strm_type_b sty,
6668: okl_strm_type_tl styt

Line 6665: okc_rules_b slh,

6661: TRUNC(ADD_MONTHS(Fnd_Date.canonical_to_date(sll.rule_information2),
6662: TO_NUMBER(SLL.rule_information3)*DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12)) - 1) end_date,
6663: styt.name stream_type
6664: FROM okc_rules_b sll,
6665: okc_rules_b slh,
6666: okc_rule_groups_b rgp,
6667: okl_strm_type_b sty,
6668: okl_strm_type_tl styt
6669: WHERE rgp.dnz_chr_id = chrID

Line 6688: FROM okc_rules_b slh,

6684: CURSOR l_fn_fee_pmtH_csr ( chrID IN OKC_K_HEADERS_B.ID%TYPE,
6685: feeLine IN OKL_K_LINES.ID%TYPE) IS
6686:
6687: SELECT slh.id
6688: FROM okc_rules_b slh,
6689: okc_rule_groups_b rgp,
6690: okl_strm_type_b sty,
6691: okl_strm_type_tl styt
6692: WHERE rgp.dnz_chr_id = chrID

Line 7372: OKC_RULES_B crl2,

7368:
7369: CURSOR get_payment_lns (p_chr_id IN NUMBER) IS
7370: SELECT rgp.id,rgp.cle_id
7371: FROM OKC_RULE_GROUPS_B rgp,
7372: OKC_RULES_B crl2,
7373: okc_k_lines_b cleb,
7374: OKL_STRM_TYPE_B stty
7375: WHERE stty.id = crl2.object1_id1
7376: AND stty.stream_type_purpose = 'RENT'

Line 7400: FROM OKC_RULES_B crl1,

7396: CURSOR get_payment_line_amt (p_rgp_id IN NUMBER, p_chr_id IN NUMBER) IS
7397: select nvl(sum(tot_amt),0)
7398: from(
7399: SELECT to_number((NVL(crl2.rule_information3,0) * NVL(crl2.rule_information6,0))) tot_amt
7400: FROM OKC_RULES_B crl1,
7401: OKC_RULES_B crl2
7402: WHERE crl1.id = crl2.object2_id1
7403: AND crl2.RULE_INFORMATION_CATEGORY = 'LASLL'
7404: AND crl1.RULE_INFORMATION_CATEGORY = 'LASLH'

Line 7401: OKC_RULES_B crl2

7397: select nvl(sum(tot_amt),0)
7398: from(
7399: SELECT to_number((NVL(crl2.rule_information3,0) * NVL(crl2.rule_information6,0))) tot_amt
7400: FROM OKC_RULES_B crl1,
7401: OKC_RULES_B crl2
7402: WHERE crl1.id = crl2.object2_id1
7403: AND crl2.RULE_INFORMATION_CATEGORY = 'LASLL'
7404: AND crl1.RULE_INFORMATION_CATEGORY = 'LASLH'
7405: AND crl1.dnz_chr_id = p_chr_id

Line 7412: FROM OKC_RULES_B crl1,

7408: AND crl2.rgp_id = p_rgp_id
7409: union all
7410: SELECT
7411: to_number(nvl(crl2.rule_information8,0)) tot_amt
7412: FROM OKC_RULES_B crl1,
7413: OKC_RULES_B crl2
7414: WHERE crl1.id = crl2.object2_id1
7415: AND crl2.RULE_INFORMATION_CATEGORY = 'LASLL'
7416: AND crl1.RULE_INFORMATION_CATEGORY = 'LASLH'

Line 7413: OKC_RULES_B crl2

7409: union all
7410: SELECT
7411: to_number(nvl(crl2.rule_information8,0)) tot_amt
7412: FROM OKC_RULES_B crl1,
7413: OKC_RULES_B crl2
7414: WHERE crl1.id = crl2.object2_id1
7415: AND crl2.RULE_INFORMATION_CATEGORY = 'LASLL'
7416: AND crl1.RULE_INFORMATION_CATEGORY = 'LASLH'
7417: AND crl1.dnz_chr_id = p_chr_id

Line 7809: OKC_RULES_B crl,

7805: crl.id,
7806: crl.object1_id1,
7807: crl.RULE_INFORMATION6
7808: FROM OKC_RULE_GROUPS_B crg,
7809: OKC_RULES_B crl,
7810: OKL_STRM_TYPE_B stty
7811: WHERE stty.id = crl.object1_id1
7812: AND stty.stream_type_purpose = 'DOWN_PAYMENT'
7813: AND crl.rgp_id = crg.id

Line 7820: CURSOR l_down_pmnt_line_csr(p_id OKC_RULES_B.ID%TYPE, p_cle_id OKC_K_LINES_B.ID%TYPE) IS

7816: AND crg.cle_id = p_cle_id
7817: AND crg.dnz_chr_id = p_chr_id;
7818: l_down_pmnt_check_rec l_down_pmnt_check_csr%ROWTYPE;
7819:
7820: CURSOR l_down_pmnt_line_csr(p_id OKC_RULES_B.ID%TYPE, p_cle_id OKC_K_LINES_B.ID%TYPE) IS
7821: SELECT crl2.object1_id1,
7822: crl2.object1_id2,
7823: crl2.rule_information2,
7824: NVL(crl2.rule_information3,0) rule_information3,

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

7822: crl2.object1_id2,
7823: crl2.rule_information2,
7824: NVL(crl2.rule_information3,0) rule_information3,
7825: NVL(crl2.rule_information6,0) rule_information6
7826: FROM OKC_RULES_B crl1, OKC_RULES_B crl2, OKC_RULE_GROUPS_B rgp
7827: WHERE crl1.id = crl2.object2_id1
7828: AND crl1.id = p_id
7829: AND rgp.cle_id = p_cle_id
7830: AND rgp.id = crl1.rgp_id

Line 8155: l_passthru_site_id OKC_RULES_B.OBJECT1_ID1%TYPE;

8151: GROUP BY sgn.value;
8152:
8153: l_tot_sub_line_amt NUMBER;
8154:
8155: l_passthru_site_id OKC_RULES_B.OBJECT1_ID1%TYPE;
8156: l_passthru_vendor_id OKC_K_PARTY_ROLES_B.OBJECT1_ID1%TYPE;
8157: l_site_valid VARCHAR2(1) := '?';
8158: l_passthru_present VARCHAR2(1) := 'N';
8159:

Line 9370: l_tax_owner okc_rules_b.RULE_INFORMATION1%TYPE;

9366:
9367: --l_hdr l_hdr_csr%ROWTYPE;
9368: l_hdrrl_rec l_hdrrl_csr%ROWTYPE;
9369: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
9370: l_tax_owner okc_rules_b.RULE_INFORMATION1%TYPE;
9371: l_purchase_opt_type okc_rules_b.RULE_INFORMATION11%TYPE;
9372: l_contract_residual_value NUMBER;
9373: l_msg_count NUMBER;
9374: l_msg_data VARCHAR2(2000);

Line 9371: l_purchase_opt_type okc_rules_b.RULE_INFORMATION11%TYPE;

9367: --l_hdr l_hdr_csr%ROWTYPE;
9368: l_hdrrl_rec l_hdrrl_csr%ROWTYPE;
9369: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
9370: l_tax_owner okc_rules_b.RULE_INFORMATION1%TYPE;
9371: l_purchase_opt_type okc_rules_b.RULE_INFORMATION11%TYPE;
9372: l_contract_residual_value NUMBER;
9373: l_msg_count NUMBER;
9374: l_msg_data VARCHAR2(2000);
9375:

Line 9555: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,

9551: * l_synd_rec l_synd_csr%ROWTYPE;
9552: *
9553: */
9554: CURSOR l_rl_csr( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
9555: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
9556: chrId OKC_RULE_GROUPS_B.DNZ_CHR_ID%TYPE ) IS
9557: SELECT crl.RULE_INFORMATION1, crl.RULE_INFORMATION2
9558: FROM OKC_RULE_GROUPS_B crg, OKC_RULES_B crl
9559: WHERE crl.rgp_id = crg.id

Line 9558: FROM OKC_RULE_GROUPS_B crg, OKC_RULES_B crl

9554: CURSOR l_rl_csr( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
9555: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
9556: chrId OKC_RULE_GROUPS_B.DNZ_CHR_ID%TYPE ) IS
9557: SELECT crl.RULE_INFORMATION1, crl.RULE_INFORMATION2
9558: FROM OKC_RULE_GROUPS_B crg, OKC_RULES_B crl
9559: WHERE crl.rgp_id = crg.id
9560: AND crg.RGD_CODE = rgcode
9561: AND crl.RULE_INFORMATION_CATEGORY = rlcat
9562: AND crg.dnz_chr_id = chrId;

Line 9634: l_auto_fixed_pur_opt_yn okc_rules_b.RULE_INFORMATION1%TYPE;

9630: i NUMBER;
9631:
9632: fnd_rec fnd_csr%ROWTYPE;
9633:
9634: l_auto_fixed_pur_opt_yn okc_rules_b.RULE_INFORMATION1%TYPE;
9635: l_evergreen_flag okc_rules_b.RULE_INFORMATION1%TYPE;
9636: l_purchase_opt_type okc_rules_b.RULE_INFORMATION11%TYPE;
9637:
9638: l_late_charge_policy OKC_RULES_B.RULE_INFORMATION1%TYPE; -- Bug 4925675

Line 9635: l_evergreen_flag okc_rules_b.RULE_INFORMATION1%TYPE;

9631:
9632: fnd_rec fnd_csr%ROWTYPE;
9633:
9634: l_auto_fixed_pur_opt_yn okc_rules_b.RULE_INFORMATION1%TYPE;
9635: l_evergreen_flag okc_rules_b.RULE_INFORMATION1%TYPE;
9636: l_purchase_opt_type okc_rules_b.RULE_INFORMATION11%TYPE;
9637:
9638: l_late_charge_policy OKC_RULES_B.RULE_INFORMATION1%TYPE; -- Bug 4925675
9639: l_rl2 l_rl_csr%ROWTYPE;

Line 9636: l_purchase_opt_type okc_rules_b.RULE_INFORMATION11%TYPE;

9632: fnd_rec fnd_csr%ROWTYPE;
9633:
9634: l_auto_fixed_pur_opt_yn okc_rules_b.RULE_INFORMATION1%TYPE;
9635: l_evergreen_flag okc_rules_b.RULE_INFORMATION1%TYPE;
9636: l_purchase_opt_type okc_rules_b.RULE_INFORMATION11%TYPE;
9637:
9638: l_late_charge_policy OKC_RULES_B.RULE_INFORMATION1%TYPE; -- Bug 4925675
9639: l_rl2 l_rl_csr%ROWTYPE;
9640: /*

Line 9638: l_late_charge_policy OKC_RULES_B.RULE_INFORMATION1%TYPE; -- Bug 4925675

9634: l_auto_fixed_pur_opt_yn okc_rules_b.RULE_INFORMATION1%TYPE;
9635: l_evergreen_flag okc_rules_b.RULE_INFORMATION1%TYPE;
9636: l_purchase_opt_type okc_rules_b.RULE_INFORMATION11%TYPE;
9637:
9638: l_late_charge_policy OKC_RULES_B.RULE_INFORMATION1%TYPE; -- Bug 4925675
9639: l_rl2 l_rl_csr%ROWTYPE;
9640: /*
9641: CURSOR bill_to_csr (p_cust_acct okx_cust_site_uses_v.cust_account_id%TYPE,
9642: p_bill_to okx_cust_site_uses_v.id1%TYPE

Line 9653: --l_cust_acct okc_rules_b.object1_id1%TYPE;

9649: AND b_status = 'A'
9650: AND cust_acct_site_status = 'A';
9651: --AND NVL(ORG_ID, -99) = SYS_CONTEXT('OKC_CONTEXT','ORG_ID');
9652:
9653: --l_cust_acct okc_rules_b.object1_id1%TYPE;
9654: l_cust_acct OKC_K_HEADERS_B.CUST_ACCT_ID%TYPE;
9655:
9656: l_bill_to okc_rules_b.object1_id1%TYPE;
9657: l_bill_to_valid VARCHAR2(1) := 'N';

Line 9656: l_bill_to okc_rules_b.object1_id1%TYPE;

9652:
9653: --l_cust_acct okc_rules_b.object1_id1%TYPE;
9654: l_cust_acct OKC_K_HEADERS_B.CUST_ACCT_ID%TYPE;
9655:
9656: l_bill_to okc_rules_b.object1_id1%TYPE;
9657: l_bill_to_valid VARCHAR2(1) := 'N';
9658: */
9659:
9660: -- Bug# 8219011

Line 10380: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,

10376: l_row_notfound BOOLEAN;
10377: l_token VARCHAR2(2000);
10378:
10379: CURSOR l_rl_csr( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
10380: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
10381: chrid OKC_RULE_GROUPS_B.DNZ_CHR_ID%TYPE ) IS
10382: SELECT crl.RULE_INFORMATION1, crl.RULE_INFORMATION2
10383: FROM OKC_RULE_GROUPS_B crg, OKC_RULES_B crl
10384: WHERE crl.rgp_id = crg.id

Line 10383: FROM OKC_RULE_GROUPS_B crg, OKC_RULES_B crl

10379: CURSOR l_rl_csr( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
10380: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
10381: chrid OKC_RULE_GROUPS_B.DNZ_CHR_ID%TYPE ) IS
10382: SELECT crl.RULE_INFORMATION1, crl.RULE_INFORMATION2
10383: FROM OKC_RULE_GROUPS_B crg, OKC_RULES_B crl
10384: WHERE crl.rgp_id = crg.id
10385: AND crg.RGD_CODE = rgcode
10386: AND crl.RULE_INFORMATION_CATEGORY = rlcat
10387: AND crg.dnz_chr_id = chrid;

Line 11193: FROM okc_rules_b rule,

11189: --Bug#3931587
11190: CURSOR pmnt_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE,
11191: p_line_type OKC_LINE_STYLES_B.LTY_CODE%TYPE) IS
11192: SELECT COUNT(1)
11193: FROM okc_rules_b rule,
11194: okc_rule_groups_b rgp,
11195: okc_k_lines_b line,
11196: okc_line_styles_b style,
11197: okl_strm_type_b strm

Line 11451: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,

11447: AND line.sts_code = sts.code
11448: AND sts.ste_code NOT IN ( 'HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED');
11449:
11450: CURSOR tax_rule_csr (rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
11451: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
11452: chrId NUMBER,
11453: cleId NUMBER) IS
11454: SELECT crl.id slh_id,
11455: crl.object1_id1,

Line 11465: OKC_RULES_B crl

11461: crl.RULE_INFORMATION6,
11462: crl.RULE_INFORMATION7,
11463: crl.RULE_INFORMATION10
11464: FROM OKC_RULE_GROUPS_B crg,
11465: OKC_RULES_B crl
11466: WHERE crl.rgp_id = crg.id
11467: AND crg.RGD_CODE = rgcode
11468: AND crl.RULE_INFORMATION_CATEGORY = rlcat
11469: AND crg.cle_id = cleId;

Line 11990: l_invoice_format OKC_RULES_B.RULE_INFORMATION1%TYPE;

11986:
11987: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
11988: x_msg_count NUMBER;
11989: x_msg_data VARCHAR2(1000);
11990: l_invoice_format OKC_RULES_B.RULE_INFORMATION1%TYPE;
11991:
11992: --Bug#3877032
11993: CURSOR l_invoice_format_csr IS
11994: SELECT rule.rule_information1

Line 11995: FROM okc_rules_b rule,

11991:
11992: --Bug#3877032
11993: CURSOR l_invoice_format_csr IS
11994: SELECT rule.rule_information1
11995: FROM okc_rules_b rule,
11996: okc_rule_groups_b rgp
11997: WHERE rule.rgp_id = rgp.id
11998: AND rgp.dnz_chr_id = p_chr_id
11999: AND rgp.chr_id = p_chr_id

Line 12219: l_invoice_format OKC_RULES_B.RULE_INFORMATION1%TYPE;

12215:
12216: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
12217: x_msg_count NUMBER;
12218: x_msg_data VARCHAR2(1000);
12219: l_invoice_format OKC_RULES_B.RULE_INFORMATION1%TYPE;
12220:
12221: CURSOR l_chr_csr (p_chr_id NUMBER) IS
12222: SELECT khr.id,
12223: khr.deal_type

Line 12257: FROM okc_rules_b rule,

12253: p_kle_id OKC_K_LINES_B.ID%TYPE) IS
12254: SELECT styt.name stream_type,
12255: rule.id rule_id,
12256: rgp.id rgp_id
12257: FROM okc_rules_b rule,
12258: okc_rule_groups_b rgp,
12259: okl_strm_type_b sty,
12260: okl_strm_type_tl styt
12261: WHERE NVL(rgp.cle_id, -1) = p_kle_id

Line 12270: CURSOR l_strm_sll_csr (p_rule_id OKC_RULES_B.ID%TYPE,

12266: AND TO_NUMBER(rule.object1_id1) = sty.id
12267: AND styt.LANGUAGE = USERENV('LANG')
12268: AND sty.id = styt.id;
12269:
12270: CURSOR l_strm_sll_csr (p_rule_id OKC_RULES_B.ID%TYPE,
12271: p_rgp_id OKC_RULE_GROUPS_B.ID%TYPE) IS
12272: SELECT Fnd_Date.canonical_to_date(sll.rule_information2) start_date,
12273: sll.rule_information1 seq,
12274: sll.rule_information6 amt,

Line 12277: FROM okc_rules_b sll

12273: sll.rule_information1 seq,
12274: sll.rule_information6 amt,
12275: sll.rule_information7 stub_day,
12276: sll.rule_information13 rate
12277: FROM okc_rules_b sll
12278: WHERE sll.rgp_id = p_rgp_id
12279: AND sll.object2_id1 = TO_CHAR(p_rule_id)
12280: AND sll.rule_information_category = 'LASLL'
12281: ORDER BY 1,2;

Line 13504: FROM okc_rules_b rul

13500: l_chr_rec l_chr_csr%ROWTYPE;
13501: /*Commented as part of Bug# 15992711
13502: CURSOR l_larles_csr(p_chr_id IN NUMBER) IS
13503: SELECT rul.rule_information1 release_asset_yn
13504: FROM okc_rules_b rul
13505: WHERE rul.dnz_chr_id = p_chr_id
13506: AND rul.rule_information_category = 'LARLES';*/
13507:
13508: --Bug# 16681373: Added check to exclude re-lease assets from this validation

Line 13944: FROM okc_rules_b slh_rbk,

13940: SELECT slh_rbk.id rbk_slh_id,
13941: rgp_rbk.id rbk_rgp_id,
13942: slh_orig.id orig_slh_id,
13943: rgp_orig.id orig_rgp_id
13944: FROM okc_rules_b slh_rbk,
13945: okc_rule_groups_b rgp_rbk,
13946: okc_rules_b slh_orig,
13947: okc_rule_groups_b rgp_orig
13948: WHERE rgp_rbk.dnz_chr_id = p_rbk_chr_id

Line 13946: okc_rules_b slh_orig,

13942: slh_orig.id orig_slh_id,
13943: rgp_orig.id orig_rgp_id
13944: FROM okc_rules_b slh_rbk,
13945: okc_rule_groups_b rgp_rbk,
13946: okc_rules_b slh_orig,
13947: okc_rule_groups_b rgp_orig
13948: WHERE rgp_rbk.dnz_chr_id = p_rbk_chr_id
13949: AND rgp_rbk.cle_id = p_rbk_cle_id
13950: AND rgp_rbk.rgd_code = 'LALEVL'

Line 13966: FROM okc_rules_b sll

13962: p_slh_id IN NUMBER) IS
13963: SELECT sll.object1_id1 frequency,
13964: NVL(sll.rule_information10,'N') arrears_yn,
13965: sll.rule_information5 structure
13966: FROM okc_rules_b sll
13967: WHERE sll.rgp_id = p_rgp_id
13968: AND sll.object2_id1 = p_slh_id
13969: AND sll.rule_information_category = 'LASLL'
13970: AND ROWNUM = 1;