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 1100: okc_rules_b rulb,

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
1104: AND rgpb.dnz_chr_id = cleb.dnz_chr_id

Line 1101: okc_rules_b rulb2,

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
1104: AND rgpb.dnz_chr_id = cleb.dnz_chr_id
1105: AND rgpb.cle_id = cleb.id

Line 1376: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,

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,
1380: stty.stream_type_purpose,

Line 1391: OKC_RULES_B crl,

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 (
1395: 'RENT', 'PRINCIPAL_PAYMENT', 'VARIABLE_INTEREST_SCHEDULE',

Line 1407: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,

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,
1411: crl.id,

Line 1422: OKC_RULES_B crl,

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
1426: AND crl.rgp_id = crg.id

Line 1433: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,

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,
1437: crl.id,

Line 1448: OKC_RULES_B crl,

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
1452: AND crl.rgp_id = crg.id

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

1455: AND crg.dnz_chr_id = chrId;
1456:
1457: l_pmnt_strm_check_rec l_pmnt_strm_check%ROWTYPE;
1458: l_pmnt_strm_check_rec2 l_pmnt_strm_check2%ROWTYPE;
1459: CURSOR l_pmnt_lns_in_hdr(p_id OKC_RULES_B.ID%TYPE, chrId NUMBER) IS
1460: SELECT
1461: crl2.object1_id1,
1462: crl2.object1_id2,
1463: crl2.rule_information2,

Line 1471: FROM OKC_RULES_B crl1, OKC_RULES_B crl2

1467: crl2.rule_information6,
1468: crl2.rule_information7,
1469: crl2.rule_information8,
1470: crl2.rule_information10
1471: FROM OKC_RULES_B crl1, OKC_RULES_B crl2
1472: WHERE crl1.id = crl2.object2_id1
1473: AND crl1.id = p_id
1474: AND crl2.RULE_INFORMATION_CATEGORY = 'LASLL'
1475: AND crl1.RULE_INFORMATION_CATEGORY = 'LASLH'

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

1476: AND crl1.dnz_chr_id = chrId
1477: AND crl2.dnz_chr_id = chrId
1478: ORDER BY crl2.rule_information2 ASC;
1479:
1480: CURSOR l_pmnt_lns_in_hdr2(p_id OKC_RULES_B.ID%TYPE, chrId NUMBER) IS
1481: SELECT
1482: crl2.object1_id1,
1483: crl2.object1_id2,
1484: crl2.rule_information2,

Line 1492: FROM OKC_RULES_B crl1, OKC_RULES_B crl2

1488: crl2.rule_information6,
1489: crl2.rule_information7,
1490: crl2.rule_information8,
1491: crl2.rule_information10
1492: FROM OKC_RULES_B crl1, OKC_RULES_B crl2
1493: WHERE crl1.id = crl2.object2_id1
1494: AND crl1.id = p_id
1495: AND crl2.RULE_INFORMATION_CATEGORY = 'LASLL'
1496: AND crl1.RULE_INFORMATION_CATEGORY = 'LASLH'

Line 1516: FROM OKC_RULES_B RULE,

1512: l_cust_print_lead_days NUMBER := null;
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'

Line 2474: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,

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
2478: SELECT crg.cle_id,

Line 2490: OKC_RULES_B crl,

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
2494: AND stty.stream_type_purpose = pmnt_strm_purpose

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

2496: AND crg.RGD_CODE = rgcode
2497: AND crl.RULE_INFORMATION_CATEGORY = rlcat
2498: AND crg.dnz_chr_id = chrId;
2499: l_pmnt_strm_check_rec l_pmnt_strm_check%ROWTYPE;
2500: CURSOR l_pmnt_lns_in_hdr(p_id OKC_RULES_B.ID%TYPE, chrId NUMBER) IS
2501: SELECT
2502: crl2.object1_id1,
2503: crl2.object1_id2,
2504: crl2.rule_information2,

Line 2512: FROM OKC_RULES_B crl1, OKC_RULES_B crl2

2508: crl2.rule_information6,
2509: crl2.rule_information7,
2510: crl2.rule_information8,
2511: crl2.rule_information10
2512: FROM OKC_RULES_B crl1, OKC_RULES_B crl2
2513: WHERE crl1.id = crl2.object2_id1
2514: AND crl1.id = p_id
2515: AND crl2.RULE_INFORMATION_CATEGORY = 'LASLL'
2516: AND crl1.RULE_INFORMATION_CATEGORY = 'LASLH'

Line 3190: FROM okc_rules_b sll,

3186: DECODE(sll.object1_id1, 'M',1,'Q',3,'S',6,'A',12)) - 1),
3187: Fnd_Date.canonical_to_date(sll.rule_information2) +
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

Line 3191: okc_rules_b slh,

3187: Fnd_Date.canonical_to_date(sll.rule_information2) +
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'

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

3200: AND sll.rgp_id = rgp.id
3201: AND NVL(sll.rule_information6,0) <> 0
3202: ORDER BY start_date, end_date;
3203:
3204: TYPE amt_type IS TABLE OF okc_rules_b.rule_information6%TYPE;
3205: pymnt_amt amt_type;
3206: TYPE sdate_type IS TABLE OF okc_rules_b.rule_information2%TYPE;
3207: start_date sdate_type;
3208: TYPE edate_type IS TABLE OF okc_rules_b.rule_information2%TYPE;

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

3202: ORDER BY start_date, end_date;
3203:
3204: TYPE amt_type IS TABLE OF okc_rules_b.rule_information6%TYPE;
3205: pymnt_amt amt_type;
3206: TYPE sdate_type IS TABLE OF okc_rules_b.rule_information2%TYPE;
3207: start_date sdate_type;
3208: TYPE edate_type IS TABLE OF okc_rules_b.rule_information2%TYPE;
3209: end_date edate_type;
3210: l_payment_amt okc_rules_b.rule_information6%TYPE;

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

3204: TYPE amt_type IS TABLE OF okc_rules_b.rule_information6%TYPE;
3205: pymnt_amt amt_type;
3206: TYPE sdate_type IS TABLE OF okc_rules_b.rule_information2%TYPE;
3207: start_date sdate_type;
3208: TYPE edate_type IS TABLE OF okc_rules_b.rule_information2%TYPE;
3209: end_date edate_type;
3210: l_payment_amt okc_rules_b.rule_information6%TYPE;
3211:
3212: --3. Disb basis for all vendors should be same

Line 3210: l_payment_amt okc_rules_b.rule_information6%TYPE;

3206: TYPE sdate_type IS TABLE OF okc_rules_b.rule_information2%TYPE;
3207: start_date sdate_type;
3208: TYPE edate_type IS TABLE OF okc_rules_b.rule_information2%TYPE;
3209: end_date edate_type;
3210: l_payment_amt okc_rules_b.rule_information6%TYPE;
3211:
3212: --3. Disb basis for all vendors should be same
3213: CURSOR disb_basis_csr (p_chr_id IN NUMBER, p_cle_id IN NUMBER) IS
3214: SELECT ppy.disbursement_basis, po.vendor_name

Line 3311: okc_rules_b rule

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
3315: AND line.sts_code = sts.code

Line 3852: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,

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

Line 3858: OKC_RULES_B crl

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
3862: AND crg.dnz_chr_id = chrId

Line 3866: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,

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
3870: SELECT crl.id,

Line 3873: OKC_RULES_B crl,

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
3877: AND crl.rgp_id = crg.id

Line 3886: okc_rules_b rule,

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)
3890: AND rgp.rgd_code = 'LALEVL'

Line 4048: okc_rules_b rule

4044: CURSOR stream_csr (p_slh_id VARCHAR2) IS
4045: SELECT strm.stream_type_purpose
4046: --SELECT strm.name
4047: FROM okl_strm_type_v strm,
4048: okc_rules_b rule
4049: WHERE rule.id = p_slh_id
4050: AND rule.rule_information_category = 'LASLH'
4051: AND rule.object1_id1 = strm.id;
4052:

Line 4057: FROM okc_rules_b rule,

4053: CURSOR hdr_stub_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
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

Line 4067: FROM okc_rules_b rule2

4063: AND rgp.cle_id IS NULL
4064: AND rule.rule_information7 IS NOT NULL
4065: AND NOT EXISTS (
4066: SELECT 'Y'
4067: FROM okc_rules_b rule2
4068: WHERE rule2.rule_information3 IS NOT NULL
4069: AND rule2.rgp_id = rgp.id
4070: AND rule2.object2_id1 = rule.object2_id1
4071: );

Line 4079: FROM okc_rules_b rule,

4075: SELECT style.lty_code,
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

Line 4094: FROM okc_rules_b rule2

4090: AND sts.ste_code NOT IN ( 'HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED')
4091: AND rule.rule_information7 IS NOT NULL
4092: AND NOT EXISTS (
4093: SELECT 'Y'
4094: FROM okc_rules_b rule2
4095: WHERE rule2.rule_information3 IS NOT NULL
4096: AND rule2.rgp_id = rgp.id
4097: AND rule2.object2_id1 = rule.object2_id1
4098: );

Line 4772: FROM okc_rules_b sll,

4768: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) mpp,
4769: ( select STYT.NAME from OKL_STRM_TYPE_B STY ,OKL_STRM_TYPE_TL STYT where STY.ID = STYT.ID AND STYT.LANGUAGE = USERENV ( 'LANG' )
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

Line 4773: okc_rules_b slh,

4769: ( select STYT.NAME from OKL_STRM_TYPE_B STY ,OKL_STRM_TYPE_TL STYT where STY.ID = STYT.ID AND STYT.LANGUAGE = USERENV ( 'LANG' )
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

Line 4797: FROM okc_rules_b sll,

4793: SELECT
4794: SUM(NVL(TO_NUMBER(SLL.rule_information3),0)) periods,
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

Line 4798: okc_rules_b slh,

4794: SUM(NVL(TO_NUMBER(SLL.rule_information3),0)) periods,
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

Line 4824: FROM okc_rules_b rule,

4820: where STY.ID = STYT.ID AND STYT.LANGUAGE = USERENV ( 'LANG' )
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

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

4833: --AND rule.object1_id1 = TO_CHAR(sty.id)
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,

Line 4843: FROM okc_rules_b sll

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
4843: FROM okc_rules_b sll
4844: WHERE sll.rgp_id = p_rgp_id
4845: AND sll.object2_id1 = TO_CHAR(p_rule_id)
4846: AND sll.rule_information_category = 'LASLL'
4847: -- cklee/mvasudev,06-02-2005,Bug#4392051/okl.h 4437938

Line 4873: FROM okc_rules_b sll,

4869: -- START: cklee/mvasudev,06-02-2005,Bug#4392051/okl.h 4437938
4870: CURSOR c_strm_sll_count (p_khr_id OKC_K_HEADERS_B.ID%TYPE,
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

Line 4874: okc_rules_b slh,

4870: CURSOR c_strm_sll_count (p_khr_id OKC_K_HEADERS_B.ID%TYPE,
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

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

4885: AND sty.id = styt.id
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

Line 4892: FROM okc_rules_b sll

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)
4895: AND sll.rule_information_category = 'LASLL'; --| 17-Jan-06 cklee Fixed bug#4956483 |
4896:

Line 5834: FROM okc_rules_b sll,

5830: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) mpp,
5831: TRUNC(ADD_MONTHS(Fnd_Date.canonical_to_date(sll.rule_information2),
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

Line 5835: okc_rules_b slh,

5831: TRUNC(ADD_MONTHS(Fnd_Date.canonical_to_date(sll.rule_information2),
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

Line 5858: FROM okc_rules_b slh,

5854: CURSOR l_rq_fee_pmtH_csr ( chrID IN OKC_K_HEADERS_B.ID%TYPE,
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

Line 6277: FROM okc_rules_b sll,

6273: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) mpp,
6274: TRUNC(ADD_MONTHS(Fnd_Date.canonical_to_date(sll.rule_information2),
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

Line 6278: okc_rules_b slh,

6274: TRUNC(ADD_MONTHS(Fnd_Date.canonical_to_date(sll.rule_information2),
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

Line 6301: FROM okc_rules_b slh,

6297: CURSOR l_fn_fee_pmtH_csr ( chrID IN OKC_K_HEADERS_B.ID%TYPE,
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

Line 6985: OKC_RULES_B crl2,

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
6989: AND stty.stream_type_purpose = 'RENT'

Line 7013: FROM OKC_RULES_B crl1,

7009: CURSOR get_payment_line_amt (p_rgp_id IN NUMBER, p_chr_id IN NUMBER) IS
7010: select nvl(sum(tot_amt),0)
7011: from(
7012: SELECT to_number((NVL(crl2.rule_information3,0) * NVL(crl2.rule_information6,0))) tot_amt
7013: FROM OKC_RULES_B crl1,
7014: OKC_RULES_B crl2
7015: WHERE crl1.id = crl2.object2_id1
7016: AND crl2.RULE_INFORMATION_CATEGORY = 'LASLL'
7017: AND crl1.RULE_INFORMATION_CATEGORY = 'LASLH'

Line 7014: OKC_RULES_B crl2

7010: select nvl(sum(tot_amt),0)
7011: from(
7012: SELECT to_number((NVL(crl2.rule_information3,0) * NVL(crl2.rule_information6,0))) tot_amt
7013: FROM OKC_RULES_B crl1,
7014: OKC_RULES_B crl2
7015: WHERE crl1.id = crl2.object2_id1
7016: AND crl2.RULE_INFORMATION_CATEGORY = 'LASLL'
7017: AND crl1.RULE_INFORMATION_CATEGORY = 'LASLH'
7018: AND crl1.dnz_chr_id = p_chr_id

Line 7025: FROM OKC_RULES_B crl1,

7021: AND crl2.rgp_id = p_rgp_id
7022: union all
7023: SELECT
7024: to_number(nvl(crl2.rule_information8,0)) tot_amt
7025: FROM OKC_RULES_B crl1,
7026: OKC_RULES_B crl2
7027: WHERE crl1.id = crl2.object2_id1
7028: AND crl2.RULE_INFORMATION_CATEGORY = 'LASLL'
7029: AND crl1.RULE_INFORMATION_CATEGORY = 'LASLH'

Line 7026: OKC_RULES_B crl2

7022: union all
7023: SELECT
7024: to_number(nvl(crl2.rule_information8,0)) tot_amt
7025: FROM OKC_RULES_B crl1,
7026: OKC_RULES_B crl2
7027: WHERE crl1.id = crl2.object2_id1
7028: AND crl2.RULE_INFORMATION_CATEGORY = 'LASLL'
7029: AND crl1.RULE_INFORMATION_CATEGORY = 'LASLH'
7030: AND crl1.dnz_chr_id = p_chr_id

Line 7415: OKC_RULES_B crl,

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'
7419: AND crl.rgp_id = crg.id

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

7422: AND crg.cle_id = p_cle_id
7423: AND crg.dnz_chr_id = p_chr_id;
7424: l_down_pmnt_check_rec l_down_pmnt_check_csr%ROWTYPE;
7425:
7426: CURSOR l_down_pmnt_line_csr(p_id OKC_RULES_B.ID%TYPE, p_cle_id OKC_K_LINES_B.ID%TYPE) IS
7427: SELECT crl2.object1_id1,
7428: crl2.object1_id2,
7429: crl2.rule_information2,
7430: NVL(crl2.rule_information3,0) rule_information3,

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 7738: l_passthru_site_id OKC_RULES_B.OBJECT1_ID1%TYPE;

7734: GROUP BY sgn.value;
7735:
7736: l_tot_sub_line_amt NUMBER;
7737:
7738: l_passthru_site_id OKC_RULES_B.OBJECT1_ID1%TYPE;
7739: l_passthru_vendor_id OKC_K_PARTY_ROLES_B.OBJECT1_ID1%TYPE;
7740: l_site_valid VARCHAR2(1) := '?';
7741: l_passthru_present VARCHAR2(1) := 'N';
7742:

Line 8949: l_tax_owner okc_rules_b.RULE_INFORMATION1%TYPE;

8945:
8946: --l_hdr l_hdr_csr%ROWTYPE;
8947: l_hdrrl_rec l_hdrrl_csr%ROWTYPE;
8948: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
8949: l_tax_owner okc_rules_b.RULE_INFORMATION1%TYPE;
8950: l_purchase_opt_type okc_rules_b.RULE_INFORMATION11%TYPE;
8951: l_contract_residual_value NUMBER;
8952: l_msg_count NUMBER;
8953: l_msg_data VARCHAR2(2000);

Line 8950: l_purchase_opt_type okc_rules_b.RULE_INFORMATION11%TYPE;

8946: --l_hdr l_hdr_csr%ROWTYPE;
8947: l_hdrrl_rec l_hdrrl_csr%ROWTYPE;
8948: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
8949: l_tax_owner okc_rules_b.RULE_INFORMATION1%TYPE;
8950: l_purchase_opt_type okc_rules_b.RULE_INFORMATION11%TYPE;
8951: l_contract_residual_value NUMBER;
8952: l_msg_count NUMBER;
8953: l_msg_data VARCHAR2(2000);
8954:

Line 9134: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,

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
9138: WHERE crl.rgp_id = crg.id

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 9213: l_auto_fixed_pur_opt_yn okc_rules_b.RULE_INFORMATION1%TYPE;

9209: i NUMBER;
9210:
9211: fnd_rec fnd_csr%ROWTYPE;
9212:
9213: l_auto_fixed_pur_opt_yn okc_rules_b.RULE_INFORMATION1%TYPE;
9214: l_evergreen_flag okc_rules_b.RULE_INFORMATION1%TYPE;
9215: l_purchase_opt_type okc_rules_b.RULE_INFORMATION11%TYPE;
9216:
9217: l_late_charge_policy OKC_RULES_B.RULE_INFORMATION1%TYPE; -- Bug 4925675

Line 9214: l_evergreen_flag okc_rules_b.RULE_INFORMATION1%TYPE;

9210:
9211: fnd_rec fnd_csr%ROWTYPE;
9212:
9213: l_auto_fixed_pur_opt_yn okc_rules_b.RULE_INFORMATION1%TYPE;
9214: l_evergreen_flag okc_rules_b.RULE_INFORMATION1%TYPE;
9215: l_purchase_opt_type okc_rules_b.RULE_INFORMATION11%TYPE;
9216:
9217: l_late_charge_policy OKC_RULES_B.RULE_INFORMATION1%TYPE; -- Bug 4925675
9218: l_rl2 l_rl_csr%ROWTYPE;

Line 9215: l_purchase_opt_type okc_rules_b.RULE_INFORMATION11%TYPE;

9211: fnd_rec fnd_csr%ROWTYPE;
9212:
9213: l_auto_fixed_pur_opt_yn okc_rules_b.RULE_INFORMATION1%TYPE;
9214: l_evergreen_flag okc_rules_b.RULE_INFORMATION1%TYPE;
9215: l_purchase_opt_type okc_rules_b.RULE_INFORMATION11%TYPE;
9216:
9217: l_late_charge_policy OKC_RULES_B.RULE_INFORMATION1%TYPE; -- Bug 4925675
9218: l_rl2 l_rl_csr%ROWTYPE;
9219: /*

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

9213: l_auto_fixed_pur_opt_yn okc_rules_b.RULE_INFORMATION1%TYPE;
9214: l_evergreen_flag okc_rules_b.RULE_INFORMATION1%TYPE;
9215: l_purchase_opt_type okc_rules_b.RULE_INFORMATION11%TYPE;
9216:
9217: l_late_charge_policy OKC_RULES_B.RULE_INFORMATION1%TYPE; -- Bug 4925675
9218: l_rl2 l_rl_csr%ROWTYPE;
9219: /*
9220: CURSOR bill_to_csr (p_cust_acct okx_cust_site_uses_v.cust_account_id%TYPE,
9221: p_bill_to okx_cust_site_uses_v.id1%TYPE

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

9228: AND b_status = 'A'
9229: AND cust_acct_site_status = 'A';
9230: --AND NVL(ORG_ID, -99) = SYS_CONTEXT('OKC_CONTEXT','ORG_ID');
9231:
9232: --l_cust_acct okc_rules_b.object1_id1%TYPE;
9233: l_cust_acct OKC_K_HEADERS_B.CUST_ACCT_ID%TYPE;
9234:
9235: l_bill_to okc_rules_b.object1_id1%TYPE;
9236: l_bill_to_valid VARCHAR2(1) := 'N';

Line 9235: l_bill_to okc_rules_b.object1_id1%TYPE;

9231:
9232: --l_cust_acct okc_rules_b.object1_id1%TYPE;
9233: l_cust_acct OKC_K_HEADERS_B.CUST_ACCT_ID%TYPE;
9234:
9235: l_bill_to okc_rules_b.object1_id1%TYPE;
9236: l_bill_to_valid VARCHAR2(1) := 'N';
9237: */
9238:
9239: -- Bug# 8219011

Line 9959: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,

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
9963: WHERE crl.rgp_id = crg.id

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 10253: ,okc_rules_b RUL

10249: ,rul.rule_information1 Release_asset_yn
10250: FROM okl_products_v pdt
10251: ,okl_k_headers_v khr
10252: ,okc_k_headers_b CHR
10253: ,okc_rules_b RUL
10254: WHERE 1=1
10255: AND khr.id = p_chr_id
10256: AND pdt_id = pdt.id
10257: AND khr.id = CHR.id

Line 10770: FROM okc_rules_b rule,

10766: --Bug#3931587
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

Line 11028: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,

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,
11032: crl.object1_id1,

Line 11042: OKC_RULES_B crl

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

Line 11567: l_invoice_format OKC_RULES_B.RULE_INFORMATION1%TYPE;

11563:
11564: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
11565: x_msg_count NUMBER;
11566: x_msg_data VARCHAR2(1000);
11567: l_invoice_format OKC_RULES_B.RULE_INFORMATION1%TYPE;
11568:
11569: --Bug#3877032
11570: CURSOR l_invoice_format_csr IS
11571: SELECT rule.rule_information1

Line 11572: FROM okc_rules_b rule,

11568:
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

Line 11796: l_invoice_format OKC_RULES_B.RULE_INFORMATION1%TYPE;

11792:
11793: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
11794: x_msg_count NUMBER;
11795: x_msg_data VARCHAR2(1000);
11796: l_invoice_format OKC_RULES_B.RULE_INFORMATION1%TYPE;
11797:
11798: CURSOR l_chr_csr (p_chr_id NUMBER) IS
11799: SELECT khr.id,
11800: khr.deal_type

Line 11834: FROM okc_rules_b rule,

11830: p_kle_id OKC_K_LINES_B.ID%TYPE) IS
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

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

11843: AND TO_NUMBER(rule.object1_id1) = sty.id
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,

Line 11854: FROM okc_rules_b sll

11850: sll.rule_information1 seq,
11851: sll.rule_information6 amt,
11852: sll.rule_information7 stub_day,
11853: sll.rule_information13 rate
11854: FROM okc_rules_b sll
11855: WHERE sll.rgp_id = p_rgp_id
11856: AND sll.object2_id1 = TO_CHAR(p_rule_id)
11857: AND sll.rule_information_category = 'LASLL'
11858: ORDER BY 1,2;