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

Line 179: okc_rule_groups_b rgp,

175: NVL(sll.rule_information10, 'N') arrears_yn,
176: FND_NUMBER.canonical_to_number(sll.rule_information6) rent_amount
177: FROM okc_rules_b sll,
178: okc_rules_b slh,
179: okc_rule_groups_b rgp,
180: okl_strm_type_b sty,
181: okl_strm_type_tl styt
182: WHERE rgp.dnz_chr_id = p_khr_id
183: AND rgp.cle_id = p_kle_id

Line 237: FROM okc_rule_groups_b crg,

233: p_kle_id NUMBER,
234: p_date date)
235: IS
236: SELECT TRUNC(FND_DATE.canonical_to_date(crl.rule_information2))
237: FROM okc_rule_groups_b crg,
238: okc_rules_b crl
239: WHERE crl.rgp_id = crg.id
240: AND crg.rgd_code = 'LALEVL'
241: AND crl.rule_information_category = 'LASLL'

Line 321: okc_rule_groups_b rgp,

317: cursor fee_strm_type_csr is
318: SELECT styt.name
319: FROM okc_rules_b sll,
320: okc_rules_b slh,
321: okc_rule_groups_b rgp,
322: okl_strm_type_b sty,
323: okl_strm_type_tl styt
324: WHERE rgp.dnz_chr_id = p_khr_id
325: AND rgp.cle_id = p_kle_id

Line 1273: okc_rule_groups_b rgp,

1269: NVL(sll.rule_information10, 'N') arrears_yn,
1270: FND_NUMBER.canonical_to_number(sll.rule_information6) rent_amount
1271: FROM okc_rules_b sll,
1272: okc_rules_b slh,
1273: okc_rule_groups_b rgp,
1274: okl_strm_type_b sty,
1275: okl_strm_type_tl styt
1276: WHERE rgp.dnz_chr_id = p_khr_id
1277: AND rgp.cle_id = p_kle_id

Line 1345: FROM okc_rule_groups_b crg,

1341: p_kle_id NUMBER,
1342: p_date date)
1343: IS
1344: SELECT TRUNC(FND_DATE.canonical_to_date(crl.rule_information2))
1345: FROM okc_rule_groups_b crg,
1346: okc_rules_b crl
1347: WHERE crl.rgp_id = crg.id
1348: AND crg.rgd_code = 'LALEVL'
1349: AND crl.rule_information_category = 'LASLL'

Line 1447: okc_rule_groups_b rgp,

1443: cursor fee_strm_type_csr is
1444: SELECT styt.name
1445: FROM okc_rules_b sll,
1446: okc_rules_b slh,
1447: okc_rule_groups_b rgp,
1448: okl_strm_type_b sty,
1449: okl_strm_type_tl styt
1450: WHERE rgp.dnz_chr_id = p_khr_id
1451: AND rgp.cle_id = p_kle_id

Line 2325: okc_rule_groups_b rgp_pay,

2321: FROM okc_k_headers_b chr_so,
2322: okl_k_headers khr_so,
2323: okc_line_styles_b lse_so,
2324: okc_k_lines_b cle_so,
2325: okc_rule_groups_b rgp_pay,
2326: okc_rules_b rul_slh,
2327: okc_rules_b rul_sll,
2328: okl_strm_type_b sty
2329: WHERE cle_so.id = p_Kle_id

Line 2902: okc_rule_groups_b rgp

2898: okl_k_lines kle,
2899: okc_line_styles_b lse,
2900: okc_rules_b sll,
2901: okc_rules_b slh,
2902: okc_rule_groups_b rgp
2903: WHERE stm.khr_id = p_khr_id
2904: --AND stm.kle_id = p_kle_id
2905: AND stm.say_code = 'WORK'
2906: AND stm.purpose_code = 'FLOW'

Line 2954: okc_rule_groups_b rgp

2950: okl_k_lines kle,
2951: okc_line_styles_b lse,
2952: okc_rules_b sll,
2953: okc_rules_b slh,
2954: okc_rule_groups_b rgp
2955: WHERE stm.khr_id = p_khr_id
2956: AND stm.kle_id = cle.id
2957: AND stm.kle_id = kle.id
2958: AND stm.say_code = 'WORK'

Line 3005: okc_rule_groups_b rgp

3001: okc_k_lines_b cle,
3002: okc_line_styles_b lse,
3003: okc_rules_b sll,
3004: okc_rules_b slh,
3005: okc_rule_groups_b rgp
3006: WHERE stm.khr_id = p_khr_id
3007: AND stm.kle_id = p_kle_id
3008: AND stm.kle_id = cle.id
3009: AND stm.say_code = 'WORK'

Line 3040: okc_rule_groups_b rgp_pay,

3036: cle_so.END_DATE
3037: FROM okc_k_headers_b chr_so,
3038: okc_line_styles_b lse_so,
3039: okc_k_lines_b cle_so,
3040: okc_rule_groups_b rgp_pay,
3041: okc_rules_b rul_slh,
3042: okc_rules_b rul_sll,
3043: okl_strm_type_b sty
3044: WHERE cle_so.id = p_kle_id

Line 3076: FROM okc_rule_groups_b rgp

3072: AND cle.id = kle.id
3073: AND chr_so.id = cle.dnz_chr_id
3074: AND trunc(chr_so.START_DATE) = trunc(cle.START_DATE)
3075: AND NOT EXISTS (SELECT 1
3076: FROM okc_rule_groups_b rgp
3077: WHERE rgp.cle_id = cle.id
3078: AND rgp.rgd_code = 'LAPSTH')
3079: AND NOT EXISTS (SELECT 1
3080: FROM okc_rule_groups_b rgp,

Line 3080: FROM okc_rule_groups_b rgp,

3076: FROM okc_rule_groups_b rgp
3077: WHERE rgp.cle_id = cle.id
3078: AND rgp.rgd_code = 'LAPSTH')
3079: AND NOT EXISTS (SELECT 1
3080: FROM okc_rule_groups_b rgp,
3081: okc_rules_b rul,
3082: okc_rules_b rul2
3083: WHERE rgp.cle_id = cle.id
3084: AND rgp.rgd_code = 'LAFEXP'

Line 3118: okc_rule_groups_b rgp,

3114: okc_line_styles_b lse,
3115: okl_k_lines kle,
3116: okc_rules_b sll,
3117: okc_rules_b slh,
3118: okc_rule_groups_b rgp,
3119: okc_rule_groups_b rgp2,
3120: okc_rules_b laptpr
3121: WHERE stm.khr_id = p_khr_id
3122: AND stm.say_code = 'WORK'

Line 3119: okc_rule_groups_b rgp2,

3115: okl_k_lines kle,
3116: okc_rules_b sll,
3117: okc_rules_b slh,
3118: okc_rule_groups_b rgp,
3119: okc_rule_groups_b rgp2,
3120: okc_rules_b laptpr
3121: WHERE stm.khr_id = p_khr_id
3122: AND stm.say_code = 'WORK'
3123: AND stm.purpose_code = 'FLOW'

Line 3158: okc_rule_groups_b rgp,

3154: DECODE(rul2.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) cf_mpp,
3155: cle.start_date start_date
3156: FROM okc_rules_b rul,
3157: okc_rules_b rul2,
3158: okc_rule_groups_b rgp,
3159: okc_k_headers_b chr_so,
3160: okc_k_lines_b cle,
3161: okc_line_styles_b lse
3162: WHERE cle.chr_id = p_khr_id

Line 3177: FROM okc_rule_groups_b rgp

3173: AND rul2.object1_id1 IS NOT NULL
3174: AND cle.dnz_chr_id = chr_so.id
3175: AND trunc(chr_so.START_DATE) = trunc(cle.START_DATE)
3176: AND NOT EXISTS (SELECT 1
3177: FROM okc_rule_groups_b rgp
3178: WHERE rgp.cle_id = cle.id
3179: AND rgp.rgd_code = 'LAPSTH');
3180: -- To get the Currency code and Precision
3181: CURSOR get_curr_code_pre(p_khr_id NUMBER)

Line 4227: okc_rule_groups_b rgp

4223: okl_strm_type_b sty,
4224: okl_strm_elements sel,
4225: okc_rules_b sll,
4226: okc_rules_b slh,
4227: okc_rule_groups_b rgp
4228: WHERE stm.khr_id = p_khr_id
4229: AND stm.say_code = 'WORK'
4230: AND stm.purpose_code IS NULL
4231: AND stm.sty_id = sty.id

Line 4247: From OKC_RULE_GROUPS_B crg,

4243: Cursor c_link_pmnts( chrId NUMBER, kleId NUMBER ) IS
4244: Select 'Y' What
4245: from dual
4246: Where Exists(Select crl.id slh_id
4247: From OKC_RULE_GROUPS_B crg,
4248: OKC_RULES_B crl,
4249: okc_K_lines_b cle_lnk,
4250: okl_K_lines kle_roll
4251: Where crl.rgp_id = crg.id

Line 4280: okc_rule_groups_b rgp

4276: okc_k_lines_b cle,
4277: okc_line_styles_b lse,
4278: okc_rules_b sll,
4279: okc_rules_b slh,
4280: okc_rule_groups_b rgp
4281: WHERE stm.khr_id = p_khr_id
4282: AND stm.say_code = 'WORK'
4283: AND stm.purpose_code IS NULL
4284: AND stm.sty_id = sty.id

Line 4290: FROM okc_rule_groups_b rgp2

4286: AND stm.id = sel.stm_id
4287: AND sel.comments IS NOT NULL
4288: AND stm.kle_id = cle.id
4289: AND NOT EXISTS (SELECT 1
4290: FROM okc_rule_groups_b rgp2
4291: WHERE rgp2.dnz_chr_id = p_khr_id
4292: AND rgp2.cle_id = cle.id
4293: AND rgp2.rgd_code = 'LAPSTH')
4294: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED')

Line 4320: okc_rule_groups_b rgp,

4316: cle.sts_code
4317: FROM okl_k_lines kle,
4318: okc_k_lines_b cle,
4319: okc_line_styles_b lse,
4320: okc_rule_groups_b rgp,
4321: okc_rules_b slh,
4322: okc_rules_b sll,
4323: okl_strm_type_b styt
4324: WHERE cle.chr_id = p_khr_id

Line 4375: okc_rule_groups_b rgp,

4371: cle.sts_code
4372: FROM okl_k_lines kle,
4373: okc_k_lines_b cle,
4374: okc_line_styles_b lse,
4375: okc_rule_groups_b rgp,
4376: okc_rules_b slh,
4377: okc_rules_b sll,
4378: okl_strm_type_b sty
4379: WHERE cle.chr_id = p_khr_id

Line 4416: FROM okc_rule_groups_b rgp

4412: AND cim.object1_id1 = sty.id
4413: AND sty.version = '1.0'
4414: AND NVL(sty.capitalize_yn,'N') <> 'Y'
4415: AND NOT EXISTS (SELECT 1
4416: FROM okc_rule_groups_b rgp
4417: WHERE rgp.cle_id = cle.id
4418: AND rgp.rgd_code = 'LAPSTH')
4419: AND NOT EXISTS (SELECT 1
4420: FROM okc_rule_groups_b rgp,

Line 4420: FROM okc_rule_groups_b rgp,

4416: FROM okc_rule_groups_b rgp
4417: WHERE rgp.cle_id = cle.id
4418: AND rgp.rgd_code = 'LAPSTH')
4419: AND NOT EXISTS (SELECT 1
4420: FROM okc_rule_groups_b rgp,
4421: okc_rules_b rul,
4422: okc_rules_b rul2
4423: WHERE rgp.cle_id = cle.id
4424: AND rgp.rgd_code = 'LAFEXP'

Line 4451: okc_rule_groups_b rgp,

4447: okc_k_lines_b cle,
4448: okc_line_styles_b lse,
4449: okc_rules_b sll,
4450: okc_rules_b slh,
4451: okc_rule_groups_b rgp,
4452: okc_rule_groups_b rgp2,
4453: okc_rules_b laptpr
4454: WHERE stm.khr_id = p_khr_id
4455: AND stm.say_code = 'WORK'

Line 4452: okc_rule_groups_b rgp2,

4448: okc_line_styles_b lse,
4449: okc_rules_b sll,
4450: okc_rules_b slh,
4451: okc_rule_groups_b rgp,
4452: okc_rule_groups_b rgp2,
4453: okc_rules_b laptpr
4454: WHERE stm.khr_id = p_khr_id
4455: AND stm.say_code = 'WORK'
4456: AND stm.purpose_code IS NULL

Line 4485: okc_rule_groups_b rgp,

4481: DECODE(rul2.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) cf_mpp,
4482: cle.start_date start_date
4483: FROM okc_rules_b rul,
4484: okc_rules_b rul2,
4485: okc_rule_groups_b rgp,
4486: okc_k_lines_b cle,
4487: okc_line_styles_b lse
4488: WHERE cle.chr_id = p_khr_id
4489: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED')

Line 4493: FROM okc_rule_groups_b rgp

4489: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED')
4490: AND cle.lse_id = lse.id
4491: AND lse.lty_code = 'FEE'
4492: AND NOT EXISTS (SELECT 1
4493: FROM okc_rule_groups_b rgp
4494: WHERE rgp.cle_id = cle.id
4495: AND rgp.rgd_code = 'LAPSTH')
4496: AND cle.id = rgp.cle_id
4497: AND rgp.rgd_code = 'LAFEXP'

Line 5846: okc_rule_groups_b rgp,

5842: NVL(sll.rule_information10, 'N') arrears_yn,
5843: FND_NUMBER.canonical_to_number(sll.rule_information6) rent_amount
5844: FROM okc_rules_b sll,
5845: okc_rules_b slh,
5846: okc_rule_groups_b rgp,
5847: okl_strm_type_b sty
5848: WHERE rgp.dnz_chr_id = p_khr_id
5849: AND rgp.cle_id = p_kle_id
5850: AND rgp.rgd_code= 'LALEVL'

Line 6337: okc_rule_groups_b rgp

6333: okc_k_lines_b cle,
6334: okc_line_styles_b lse,
6335: okc_rules_b sll,
6336: okc_rules_b slh,
6337: okc_rule_groups_b rgp
6338: WHERE stm.khr_id = p_khr_id
6339: AND stm.kle_id = p_kle_id
6340: AND stm.kle_id = cle.id
6341: AND stm.say_code = 'WORK'

Line 6372: okc_rule_groups_b rgp_pay,

6368: cle_so.END_DATE
6369: FROM okc_k_headers_b chr_so,
6370: okc_line_styles_b lse_so,
6371: okc_k_lines_b cle_so,
6372: okc_rule_groups_b rgp_pay,
6373: okc_rules_b rul_slh,
6374: okc_rules_b rul_sll,
6375: okl_strm_type_b styt
6376: WHERE cle_so.id = p_kle_id

Line 7051: okc_rule_groups_b rgp_rv,

7047: FROM okc_k_headers_b chr_rv,
7048: okc_line_styles_b lse_rv,
7049: okc_k_lines_b cle_rv,
7050: okc_rules_b rul_rv,
7051: okc_rule_groups_b rgp_rv,
7052: okc_line_styles_b lse_so,
7053: okc_k_lines_b cle_so,
7054: okc_rules_b rul_so,
7055: okc_rule_groups_b rgp_so,

Line 7055: okc_rule_groups_b rgp_so,

7051: okc_rule_groups_b rgp_rv,
7052: okc_line_styles_b lse_so,
7053: okc_k_lines_b cle_so,
7054: okc_rules_b rul_so,
7055: okc_rule_groups_b rgp_so,
7056: okc_rule_groups_b rgp_pay,
7057: okc_rules_b rul_slh,
7058: okc_rules_b rul_sll,
7059: okl_strm_type_b styt

Line 7056: okc_rule_groups_b rgp_pay,

7052: okc_line_styles_b lse_so,
7053: okc_k_lines_b cle_so,
7054: okc_rules_b rul_so,
7055: okc_rule_groups_b rgp_so,
7056: okc_rule_groups_b rgp_pay,
7057: okc_rules_b rul_slh,
7058: okc_rules_b rul_sll,
7059: okl_strm_type_b styt
7060: WHERE rgp_so.cle_id = p_kle_id

Line 7157: okc_rule_groups_b rgp,

7153: okl_k_lines kle,
7154: okc_line_styles_b lse,
7155: okc_rules_b sll,
7156: okc_rules_b slh,
7157: okc_rule_groups_b rgp,
7158: okl_strm_type_tl stm
7159: WHERE chr_so.id = p_khr_id
7160: and cle.sts_code in( 'INCOMPLETE', 'COMPLETE')--'ENTERED'
7161: AND cle.dnz_chr_id = chr_so.id

Line 7758: okc_rule_groups_b rgp,

7754: cle.start_date
7755: FROM okl_k_lines kle,
7756: okc_k_lines_b cle,
7757: okc_line_styles_b lse,
7758: okc_rule_groups_b rgp,
7759: okc_rules_b slh,
7760: okc_rules_b sll,
7761: okl_strm_type_b styt
7762: WHERE cle.chr_id = p_khr_id

Line 8162: okc_rule_groups_b rgp

8158: okl_strm_type_b sty,
8159: okl_strm_elements sel,
8160: okc_rules_b sll,
8161: okc_rules_b slh,
8162: okc_rule_groups_b rgp
8163: WHERE stm.khr_id = p_khr_id
8164: AND stm.say_code = 'WORK'
8165: AND stm.purpose_code IS NULL
8166: AND stm.sty_id = sty.id

Line 8182: From OKC_RULE_GROUPS_B crg,

8178: Cursor c_link_pmnts( chrId NUMBER, kleId NUMBER ) IS
8179: Select 'Y' What
8180: from dual
8181: Where Exists(Select crl.id slh_id
8182: From OKC_RULE_GROUPS_B crg,
8183: OKC_RULES_B crl,
8184: okc_K_lines_b cle_lnk,
8185: okl_K_lines kle_roll
8186: Where crl.rgp_id = crg.id

Line 8213: okc_rule_groups_b rgp

8209: okc_k_lines_b cle,
8210: okc_line_styles_b lse,
8211: okc_rules_b sll,
8212: okc_rules_b slh,
8213: okc_rule_groups_b rgp
8214: WHERE stm.khr_id = p_khr_id
8215: AND stm.say_code = 'WORK'
8216: AND stm.purpose_code IS NULL
8217: AND stm.sty_id = sty.id

Line 8223: FROM okc_rule_groups_b rgp2

8219: AND stm.id = sel.stm_id
8220: AND sel.comments IS NOT NULL
8221: AND stm.kle_id = cle.id
8222: AND NOT EXISTS (SELECT 1
8223: FROM okc_rule_groups_b rgp2
8224: WHERE rgp2.dnz_chr_id = p_khr_id
8225: AND rgp2.cle_id = cle.id
8226: AND rgp2.rgd_code = 'LAPSTH')
8227: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED')

Line 8258: okc_rule_groups_b rgp

8254: okl_k_lines kle,
8255: okc_line_styles_b lse,
8256: okc_rules_b sll,
8257: okc_rules_b slh,
8258: okc_rule_groups_b rgp
8259: WHERE stm.khr_id = p_khr_id
8260: AND stm.say_code = 'WORK'
8261: AND stm.purpose_code IS NULL
8262: AND stm.sty_id = sty.id

Line 8269: FROM okc_rule_groups_b rgp2

8265: AND sel.comments IS NOT NULL
8266: AND stm.kle_id = cle.id
8267: AND cle.id = kle.id
8268: AND NOT EXISTS (SELECT 1
8269: FROM okc_rule_groups_b rgp2
8270: WHERE rgp2.dnz_chr_id = p_khr_id
8271: AND rgp2.cle_id = cle.id
8272: AND rgp2.rgd_code = 'LAPSTH')
8273: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED')

Line 8301: okc_rule_groups_b rgp,

8297: cle.sts_code
8298: FROM okl_k_lines kle,
8299: okc_k_lines_b cle,
8300: okc_line_styles_b lse,
8301: okc_rule_groups_b rgp,
8302: okc_rules_b slh,
8303: okc_rules_b sll,
8304: okl_strm_type_b sty
8305: WHERE cle.chr_id = p_khr_id

Line 8356: okc_rule_groups_b rgp,

8352: cle.sts_code
8353: FROM okl_k_lines kle,
8354: okc_k_lines_b cle,
8355: okc_line_styles_b lse,
8356: okc_rule_groups_b rgp,
8357: okc_rules_b slh,
8358: okc_rules_b sll,
8359: okl_strm_type_b sty
8360: WHERE cle.chr_id = p_khr_id

Line 8397: FROM okc_rule_groups_b rgp

8393: AND cim.object1_id1 = sty.id
8394: AND sty.version = '1.0'
8395: AND NVL(sty.capitalize_yn,'N') <> 'Y'
8396: AND NOT EXISTS (SELECT 1
8397: FROM okc_rule_groups_b rgp
8398: WHERE rgp.cle_id = cle.id
8399: AND rgp.rgd_code = 'LAPSTH')
8400: AND NOT EXISTS (SELECT 1
8401: FROM okc_rule_groups_b rgp,

Line 8401: FROM okc_rule_groups_b rgp,

8397: FROM okc_rule_groups_b rgp
8398: WHERE rgp.cle_id = cle.id
8399: AND rgp.rgd_code = 'LAPSTH')
8400: AND NOT EXISTS (SELECT 1
8401: FROM okc_rule_groups_b rgp,
8402: okc_rules_b rul,
8403: okc_rules_b rul2
8404: WHERE rgp.cle_id = cle.id
8405: AND rgp.rgd_code = 'LAFEXP'

Line 8426: okc_rule_groups_b rgp,

8422: cle.start_date start_date,
8423: kle.fee_type
8424: FROM okc_rules_b rul,
8425: okc_rules_b rul2,
8426: okc_rule_groups_b rgp,
8427: okc_k_lines_b cle,
8428: okl_k_lines kle,
8429: okc_line_styles_b lse
8430: WHERE cle.chr_id = p_khr_id

Line 8435: FROM okc_rule_groups_b rgp

8431: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED')
8432: AND cle.lse_id = lse.id
8433: AND lse.lty_code = 'FEE'
8434: AND NOT EXISTS (SELECT 1
8435: FROM okc_rule_groups_b rgp
8436: WHERE rgp.cle_id = cle.id
8437: AND rgp.rgd_code = 'LAPSTH')
8438: AND cle.id = rgp.cle_id
8439: AND cle.id = kle.id

Line 9560: okc_rule_groups_b rgp_rv,

9556: FROM okc_k_headers_b chr_rv,
9557: okc_line_styles_b lse_rv,
9558: okc_k_lines_b cle_rv,
9559: okc_rules_b rul_rv,
9560: okc_rule_groups_b rgp_rv,
9561: okc_line_styles_b lse_so,
9562: okc_k_lines_b cle_so,
9563: okc_rules_b rul_so,
9564: okc_rule_groups_b rgp_so,

Line 9564: okc_rule_groups_b rgp_so,

9560: okc_rule_groups_b rgp_rv,
9561: okc_line_styles_b lse_so,
9562: okc_k_lines_b cle_so,
9563: okc_rules_b rul_so,
9564: okc_rule_groups_b rgp_so,
9565: okc_rule_groups_b rgp_pay,
9566: okc_rules_b rul_slh,
9567: okc_rules_b rul_sll,
9568: okl_strm_type_b sty

Line 9565: okc_rule_groups_b rgp_pay,

9561: okc_line_styles_b lse_so,
9562: okc_k_lines_b cle_so,
9563: okc_rules_b rul_so,
9564: okc_rule_groups_b rgp_so,
9565: okc_rule_groups_b rgp_pay,
9566: okc_rules_b rul_slh,
9567: okc_rules_b rul_sll,
9568: okl_strm_type_b sty
9569: WHERE rgp_so.cle_id = p_kle_id

Line 9664: okc_rule_groups_b rgp,

9660: okl_k_lines kle,
9661: okc_line_styles_b lse,
9662: okc_rules_b sll,
9663: okc_rules_b slh,
9664: okc_rule_groups_b rgp,
9665: okl_strm_type_b stm
9666: WHERE chr_so.id = p_khr_id
9667: and cle.sts_code in( 'COMPLETE', 'INCOMPLETE')--'ENTERED'
9668: AND cle.dnz_chr_id = chr_so.id

Line 9703: okc_rule_groups_b rgp,

9699: okl_k_lines kle,
9700: okc_line_styles_b lse,
9701: okc_rules_b sll,
9702: okc_rules_b slh,
9703: okc_rule_groups_b rgp,
9704: okl_strm_type_b stm
9705: WHERE chr_so.id = p_khr_id
9706: and cle.sts_code in( 'COMPLETE', 'INCOMPLETE')--'ENTERED'
9707: AND cle.dnz_chr_id = chr_so.id

Line 10769: okc_rule_groups_b rgp,

10765: NVL(sll.rule_information10, 'N') arrears_yn,
10766: FND_NUMBER.canonical_to_number(sll.rule_information6) rent_amount
10767: FROM okc_rules_b sll,
10768: okc_rules_b slh,
10769: okc_rule_groups_b rgp,
10770: okl_strm_type_b sty,
10771: okl_strm_type_tl styt
10772: WHERE rgp.dnz_chr_id = p_khr_id
10773: AND rgp.rgd_code= 'LALEVL'