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 1266: okc_rule_groups_b rgp,

1262: NVL(sll.rule_information10, 'N') arrears_yn,
1263: FND_NUMBER.canonical_to_number(sll.rule_information6) rent_amount
1264: FROM okc_rules_b sll,
1265: okc_rules_b slh,
1266: okc_rule_groups_b rgp,
1267: okl_strm_type_b sty,
1268: okl_strm_type_tl styt
1269: WHERE rgp.dnz_chr_id = p_khr_id
1270: AND rgp.cle_id = p_kle_id

Line 1332: FROM okc_rule_groups_b crg,

1328: p_kle_id NUMBER,
1329: p_date date)
1330: IS
1331: SELECT TRUNC(FND_DATE.canonical_to_date(crl.rule_information2))
1332: FROM okc_rule_groups_b crg,
1333: okc_rules_b crl
1334: WHERE crl.rgp_id = crg.id
1335: AND crg.rgd_code = 'LALEVL'
1336: AND crl.rule_information_category = 'LASLL'

Line 1432: okc_rule_groups_b rgp,

1428: cursor fee_strm_type_csr is
1429: SELECT styt.name
1430: FROM okc_rules_b sll,
1431: okc_rules_b slh,
1432: okc_rule_groups_b rgp,
1433: okl_strm_type_b sty,
1434: okl_strm_type_tl styt
1435: WHERE rgp.dnz_chr_id = p_khr_id
1436: AND rgp.cle_id = p_kle_id

Line 2725: okc_rule_groups_b rgp_pay,

2721: FROM okc_k_headers_b chr_so,
2722: okl_k_headers khr_so,
2723: okc_line_styles_b lse_so,
2724: okc_k_lines_b cle_so,
2725: okc_rule_groups_b rgp_pay,
2726: okc_rules_b rul_slh,
2727: okc_rules_b rul_sll,
2728: okl_strm_type_b sty
2729: WHERE cle_so.id = p_Kle_id

Line 3302: okc_rule_groups_b rgp

3298: okl_k_lines kle,
3299: okc_line_styles_b lse,
3300: okc_rules_b sll,
3301: okc_rules_b slh,
3302: okc_rule_groups_b rgp
3303: WHERE stm.khr_id = p_khr_id
3304: --AND stm.kle_id = p_kle_id
3305: AND stm.say_code = 'WORK'
3306: AND stm.purpose_code = 'FLOW'

Line 3354: okc_rule_groups_b rgp

3350: okl_k_lines kle,
3351: okc_line_styles_b lse,
3352: okc_rules_b sll,
3353: okc_rules_b slh,
3354: okc_rule_groups_b rgp
3355: WHERE stm.khr_id = p_khr_id
3356: AND stm.kle_id = cle.id
3357: AND stm.kle_id = kle.id
3358: AND stm.say_code = 'WORK'

Line 3405: okc_rule_groups_b rgp

3401: okc_k_lines_b cle,
3402: okc_line_styles_b lse,
3403: okc_rules_b sll,
3404: okc_rules_b slh,
3405: okc_rule_groups_b rgp
3406: WHERE stm.khr_id = p_khr_id
3407: AND stm.kle_id = p_kle_id
3408: AND stm.kle_id = cle.id
3409: AND stm.say_code = 'WORK'

Line 3440: okc_rule_groups_b rgp_pay,

3436: cle_so.END_DATE
3437: FROM okc_k_headers_b chr_so,
3438: okc_line_styles_b lse_so,
3439: okc_k_lines_b cle_so,
3440: okc_rule_groups_b rgp_pay,
3441: okc_rules_b rul_slh,
3442: okc_rules_b rul_sll,
3443: okl_strm_type_b sty
3444: WHERE cle_so.id = p_kle_id

Line 3476: FROM okc_rule_groups_b rgp

3472: AND cle.id = kle.id
3473: AND chr_so.id = cle.dnz_chr_id
3474: AND trunc(chr_so.START_DATE) = trunc(cle.START_DATE)
3475: AND NOT EXISTS (SELECT 1
3476: FROM okc_rule_groups_b rgp
3477: WHERE rgp.cle_id = cle.id
3478: AND rgp.rgd_code = 'LAPSTH')
3479: AND NOT EXISTS (SELECT 1
3480: FROM okc_rule_groups_b rgp,

Line 3480: FROM okc_rule_groups_b rgp,

3476: FROM okc_rule_groups_b rgp
3477: WHERE rgp.cle_id = cle.id
3478: AND rgp.rgd_code = 'LAPSTH')
3479: AND NOT EXISTS (SELECT 1
3480: FROM okc_rule_groups_b rgp,
3481: okc_rules_b rul,
3482: okc_rules_b rul2
3483: WHERE rgp.cle_id = cle.id
3484: AND rgp.rgd_code = 'LAFEXP'

Line 3518: okc_rule_groups_b rgp,

3514: okc_line_styles_b lse,
3515: okl_k_lines kle,
3516: okc_rules_b sll,
3517: okc_rules_b slh,
3518: okc_rule_groups_b rgp,
3519: okc_rule_groups_b rgp2,
3520: okc_rules_b laptpr
3521: WHERE stm.khr_id = p_khr_id
3522: AND stm.say_code = 'WORK'

Line 3519: okc_rule_groups_b rgp2,

3515: okl_k_lines kle,
3516: okc_rules_b sll,
3517: okc_rules_b slh,
3518: okc_rule_groups_b rgp,
3519: okc_rule_groups_b rgp2,
3520: okc_rules_b laptpr
3521: WHERE stm.khr_id = p_khr_id
3522: AND stm.say_code = 'WORK'
3523: AND stm.purpose_code = 'FLOW'

Line 3558: okc_rule_groups_b rgp,

3554: DECODE(rul2.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) cf_mpp,
3555: cle.start_date start_date
3556: FROM okc_rules_b rul,
3557: okc_rules_b rul2,
3558: okc_rule_groups_b rgp,
3559: okc_k_headers_b chr_so,
3560: okc_k_lines_b cle,
3561: okc_line_styles_b lse
3562: WHERE cle.chr_id = p_khr_id

Line 3577: FROM okc_rule_groups_b rgp

3573: AND rul2.object1_id1 IS NOT NULL
3574: AND cle.dnz_chr_id = chr_so.id
3575: AND trunc(chr_so.START_DATE) = trunc(cle.START_DATE)
3576: AND NOT EXISTS (SELECT 1
3577: FROM okc_rule_groups_b rgp
3578: WHERE rgp.cle_id = cle.id
3579: AND rgp.rgd_code = 'LAPSTH');
3580: -- To get the Currency code and Precision
3581: CURSOR get_curr_code_pre(p_khr_id NUMBER)

Line 4627: okc_rule_groups_b rgp

4623: okl_strm_type_b sty,
4624: okl_strm_elements sel,
4625: okc_rules_b sll,
4626: okc_rules_b slh,
4627: okc_rule_groups_b rgp
4628: WHERE stm.khr_id = p_khr_id
4629: AND stm.say_code = 'WORK'
4630: AND stm.purpose_code IS NULL
4631: AND stm.sty_id = sty.id

Line 4647: From OKC_RULE_GROUPS_B crg,

4643: Cursor c_link_pmnts( chrId NUMBER, kleId NUMBER ) IS
4644: Select 'Y' What
4645: from dual
4646: Where Exists(Select crl.id slh_id
4647: From OKC_RULE_GROUPS_B crg,
4648: OKC_RULES_B crl,
4649: okc_K_lines_b cle_lnk,
4650: okl_K_lines kle_roll
4651: Where crl.rgp_id = crg.id

Line 4680: okc_rule_groups_b rgp

4676: okc_k_lines_b cle,
4677: okc_line_styles_b lse,
4678: okc_rules_b sll,
4679: okc_rules_b slh,
4680: okc_rule_groups_b rgp
4681: WHERE stm.khr_id = p_khr_id
4682: AND stm.say_code = 'WORK'
4683: AND stm.purpose_code IS NULL
4684: AND stm.sty_id = sty.id

Line 4690: FROM okc_rule_groups_b rgp2

4686: AND stm.id = sel.stm_id
4687: AND sel.comments IS NOT NULL
4688: AND stm.kle_id = cle.id
4689: AND NOT EXISTS (SELECT 1
4690: FROM okc_rule_groups_b rgp2
4691: WHERE rgp2.dnz_chr_id = p_khr_id
4692: AND rgp2.cle_id = cle.id
4693: AND rgp2.rgd_code = 'LAPSTH')
4694: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED')

Line 4720: okc_rule_groups_b rgp,

4716: cle.sts_code
4717: FROM okl_k_lines kle,
4718: okc_k_lines_b cle,
4719: okc_line_styles_b lse,
4720: okc_rule_groups_b rgp,
4721: okc_rules_b slh,
4722: okc_rules_b sll,
4723: okl_strm_type_b styt
4724: WHERE cle.chr_id = p_khr_id

Line 4775: okc_rule_groups_b rgp,

4771: cle.sts_code
4772: FROM okl_k_lines kle,
4773: okc_k_lines_b cle,
4774: okc_line_styles_b lse,
4775: okc_rule_groups_b rgp,
4776: okc_rules_b slh,
4777: okc_rules_b sll,
4778: okl_strm_type_b sty
4779: WHERE cle.chr_id = p_khr_id

Line 4816: FROM okc_rule_groups_b rgp

4812: AND cim.object1_id1 = sty.id
4813: AND sty.version = '1.0'
4814: AND NVL(sty.capitalize_yn,'N') <> 'Y'
4815: AND NOT EXISTS (SELECT 1
4816: FROM okc_rule_groups_b rgp
4817: WHERE rgp.cle_id = cle.id
4818: AND rgp.rgd_code = 'LAPSTH')
4819: AND NOT EXISTS (SELECT 1
4820: FROM okc_rule_groups_b rgp,

Line 4820: FROM okc_rule_groups_b rgp,

4816: FROM okc_rule_groups_b rgp
4817: WHERE rgp.cle_id = cle.id
4818: AND rgp.rgd_code = 'LAPSTH')
4819: AND NOT EXISTS (SELECT 1
4820: FROM okc_rule_groups_b rgp,
4821: okc_rules_b rul,
4822: okc_rules_b rul2
4823: WHERE rgp.cle_id = cle.id
4824: AND rgp.rgd_code = 'LAFEXP'

Line 4851: okc_rule_groups_b rgp,

4847: okc_k_lines_b cle,
4848: okc_line_styles_b lse,
4849: okc_rules_b sll,
4850: okc_rules_b slh,
4851: okc_rule_groups_b rgp,
4852: okc_rule_groups_b rgp2,
4853: okc_rules_b laptpr
4854: WHERE stm.khr_id = p_khr_id
4855: AND stm.say_code = 'WORK'

Line 4852: okc_rule_groups_b rgp2,

4848: okc_line_styles_b lse,
4849: okc_rules_b sll,
4850: okc_rules_b slh,
4851: okc_rule_groups_b rgp,
4852: okc_rule_groups_b rgp2,
4853: okc_rules_b laptpr
4854: WHERE stm.khr_id = p_khr_id
4855: AND stm.say_code = 'WORK'
4856: AND stm.purpose_code IS NULL

Line 4885: okc_rule_groups_b rgp,

4881: DECODE(rul2.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) cf_mpp,
4882: cle.start_date start_date
4883: FROM okc_rules_b rul,
4884: okc_rules_b rul2,
4885: okc_rule_groups_b rgp,
4886: okc_k_lines_b cle,
4887: okc_line_styles_b lse
4888: WHERE cle.chr_id = p_khr_id
4889: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED')

Line 4893: FROM okc_rule_groups_b rgp

4889: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED')
4890: AND cle.lse_id = lse.id
4891: AND lse.lty_code = 'FEE'
4892: AND NOT EXISTS (SELECT 1
4893: FROM okc_rule_groups_b rgp
4894: WHERE rgp.cle_id = cle.id
4895: AND rgp.rgd_code = 'LAPSTH')
4896: AND cle.id = rgp.cle_id
4897: AND rgp.rgd_code = 'LAFEXP'

Line 6236: okc_rule_groups_b rgp,

6232: NVL(sll.rule_information10, 'N') arrears_yn,
6233: FND_NUMBER.canonical_to_number(sll.rule_information6) rent_amount
6234: FROM okc_rules_b sll,
6235: okc_rules_b slh,
6236: okc_rule_groups_b rgp,
6237: okl_strm_type_b sty
6238: WHERE rgp.dnz_chr_id = p_khr_id
6239: AND rgp.cle_id = p_kle_id
6240: AND rgp.rgd_code= 'LALEVL'

Line 6727: okc_rule_groups_b rgp

6723: okc_k_lines_b cle,
6724: okc_line_styles_b lse,
6725: okc_rules_b sll,
6726: okc_rules_b slh,
6727: okc_rule_groups_b rgp
6728: WHERE stm.khr_id = p_khr_id
6729: AND stm.kle_id = p_kle_id
6730: AND stm.kle_id = cle.id
6731: AND stm.say_code = 'WORK'

Line 6762: okc_rule_groups_b rgp_pay,

6758: cle_so.END_DATE
6759: FROM okc_k_headers_b chr_so,
6760: okc_line_styles_b lse_so,
6761: okc_k_lines_b cle_so,
6762: okc_rule_groups_b rgp_pay,
6763: okc_rules_b rul_slh,
6764: okc_rules_b rul_sll,
6765: okl_strm_type_b styt
6766: WHERE cle_so.id = p_kle_id

Line 7441: okc_rule_groups_b rgp_rv,

7437: FROM okc_k_headers_b chr_rv,
7438: okc_line_styles_b lse_rv,
7439: okc_k_lines_b cle_rv,
7440: okc_rules_b rul_rv,
7441: okc_rule_groups_b rgp_rv,
7442: okc_line_styles_b lse_so,
7443: okc_k_lines_b cle_so,
7444: okc_rules_b rul_so,
7445: okc_rule_groups_b rgp_so,

Line 7445: okc_rule_groups_b rgp_so,

7441: okc_rule_groups_b rgp_rv,
7442: okc_line_styles_b lse_so,
7443: okc_k_lines_b cle_so,
7444: okc_rules_b rul_so,
7445: okc_rule_groups_b rgp_so,
7446: okc_rule_groups_b rgp_pay,
7447: okc_rules_b rul_slh,
7448: okc_rules_b rul_sll,
7449: okl_strm_type_b styt

Line 7446: okc_rule_groups_b rgp_pay,

7442: okc_line_styles_b lse_so,
7443: okc_k_lines_b cle_so,
7444: okc_rules_b rul_so,
7445: okc_rule_groups_b rgp_so,
7446: okc_rule_groups_b rgp_pay,
7447: okc_rules_b rul_slh,
7448: okc_rules_b rul_sll,
7449: okl_strm_type_b styt
7450: WHERE rgp_so.cle_id = p_kle_id

Line 7547: okc_rule_groups_b rgp,

7543: okl_k_lines kle,
7544: okc_line_styles_b lse,
7545: okc_rules_b sll,
7546: okc_rules_b slh,
7547: okc_rule_groups_b rgp,
7548: okl_strm_type_tl stm
7549: WHERE chr_so.id = p_khr_id
7550: and cle.sts_code in( 'INCOMPLETE', 'COMPLETE')--'ENTERED'
7551: AND cle.dnz_chr_id = chr_so.id

Line 8148: okc_rule_groups_b rgp,

8144: cle.start_date
8145: FROM okl_k_lines kle,
8146: okc_k_lines_b cle,
8147: okc_line_styles_b lse,
8148: okc_rule_groups_b rgp,
8149: okc_rules_b slh,
8150: okc_rules_b sll,
8151: okl_strm_type_b styt
8152: WHERE cle.chr_id = p_khr_id

Line 8552: okc_rule_groups_b rgp

8548: okl_strm_type_b sty,
8549: okl_strm_elements sel,
8550: okc_rules_b sll,
8551: okc_rules_b slh,
8552: okc_rule_groups_b rgp
8553: WHERE stm.khr_id = p_khr_id
8554: AND stm.say_code = 'WORK'
8555: AND stm.purpose_code IS NULL
8556: AND stm.sty_id = sty.id

Line 8572: From OKC_RULE_GROUPS_B crg,

8568: Cursor c_link_pmnts( chrId NUMBER, kleId NUMBER ) IS
8569: Select 'Y' What
8570: from dual
8571: Where Exists(Select crl.id slh_id
8572: From OKC_RULE_GROUPS_B crg,
8573: OKC_RULES_B crl,
8574: okc_K_lines_b cle_lnk,
8575: okl_K_lines kle_roll
8576: Where crl.rgp_id = crg.id

Line 8603: okc_rule_groups_b rgp

8599: okc_k_lines_b cle,
8600: okc_line_styles_b lse,
8601: okc_rules_b sll,
8602: okc_rules_b slh,
8603: okc_rule_groups_b rgp
8604: WHERE stm.khr_id = p_khr_id
8605: AND stm.say_code = 'WORK'
8606: AND stm.purpose_code IS NULL
8607: AND stm.sty_id = sty.id

Line 8613: FROM okc_rule_groups_b rgp2

8609: AND stm.id = sel.stm_id
8610: AND sel.comments IS NOT NULL
8611: AND stm.kle_id = cle.id
8612: AND NOT EXISTS (SELECT 1
8613: FROM okc_rule_groups_b rgp2
8614: WHERE rgp2.dnz_chr_id = p_khr_id
8615: AND rgp2.cle_id = cle.id
8616: AND rgp2.rgd_code = 'LAPSTH')
8617: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED')

Line 8648: okc_rule_groups_b rgp

8644: okl_k_lines kle,
8645: okc_line_styles_b lse,
8646: okc_rules_b sll,
8647: okc_rules_b slh,
8648: okc_rule_groups_b rgp
8649: WHERE stm.khr_id = p_khr_id
8650: AND stm.say_code = 'WORK'
8651: AND stm.purpose_code IS NULL
8652: AND stm.sty_id = sty.id

Line 8659: FROM okc_rule_groups_b rgp2

8655: AND sel.comments IS NOT NULL
8656: AND stm.kle_id = cle.id
8657: AND cle.id = kle.id
8658: AND NOT EXISTS (SELECT 1
8659: FROM okc_rule_groups_b rgp2
8660: WHERE rgp2.dnz_chr_id = p_khr_id
8661: AND rgp2.cle_id = cle.id
8662: AND rgp2.rgd_code = 'LAPSTH')
8663: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED')

Line 8691: okc_rule_groups_b rgp,

8687: cle.sts_code
8688: FROM okl_k_lines kle,
8689: okc_k_lines_b cle,
8690: okc_line_styles_b lse,
8691: okc_rule_groups_b rgp,
8692: okc_rules_b slh,
8693: okc_rules_b sll,
8694: okl_strm_type_b sty
8695: WHERE cle.chr_id = p_khr_id

Line 8746: okc_rule_groups_b rgp,

8742: cle.sts_code
8743: FROM okl_k_lines kle,
8744: okc_k_lines_b cle,
8745: okc_line_styles_b lse,
8746: okc_rule_groups_b rgp,
8747: okc_rules_b slh,
8748: okc_rules_b sll,
8749: okl_strm_type_b sty
8750: WHERE cle.chr_id = p_khr_id

Line 8787: FROM okc_rule_groups_b rgp

8783: AND cim.object1_id1 = sty.id
8784: AND sty.version = '1.0'
8785: AND NVL(sty.capitalize_yn,'N') <> 'Y'
8786: AND NOT EXISTS (SELECT 1
8787: FROM okc_rule_groups_b rgp
8788: WHERE rgp.cle_id = cle.id
8789: AND rgp.rgd_code = 'LAPSTH')
8790: AND NOT EXISTS (SELECT 1
8791: FROM okc_rule_groups_b rgp,

Line 8791: FROM okc_rule_groups_b rgp,

8787: FROM okc_rule_groups_b rgp
8788: WHERE rgp.cle_id = cle.id
8789: AND rgp.rgd_code = 'LAPSTH')
8790: AND NOT EXISTS (SELECT 1
8791: FROM okc_rule_groups_b rgp,
8792: okc_rules_b rul,
8793: okc_rules_b rul2
8794: WHERE rgp.cle_id = cle.id
8795: AND rgp.rgd_code = 'LAFEXP'

Line 8816: okc_rule_groups_b rgp,

8812: cle.start_date start_date,
8813: kle.fee_type
8814: FROM okc_rules_b rul,
8815: okc_rules_b rul2,
8816: okc_rule_groups_b rgp,
8817: okc_k_lines_b cle,
8818: okl_k_lines kle,
8819: okc_line_styles_b lse
8820: WHERE cle.chr_id = p_khr_id

Line 8825: FROM okc_rule_groups_b rgp

8821: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED')
8822: AND cle.lse_id = lse.id
8823: AND lse.lty_code = 'FEE'
8824: AND NOT EXISTS (SELECT 1
8825: FROM okc_rule_groups_b rgp
8826: WHERE rgp.cle_id = cle.id
8827: AND rgp.rgd_code = 'LAPSTH')
8828: AND cle.id = rgp.cle_id
8829: AND cle.id = kle.id

Line 9945: okc_rule_groups_b rgp_rv,

9941: FROM okc_k_headers_b chr_rv,
9942: okc_line_styles_b lse_rv,
9943: okc_k_lines_b cle_rv,
9944: okc_rules_b rul_rv,
9945: okc_rule_groups_b rgp_rv,
9946: okc_line_styles_b lse_so,
9947: okc_k_lines_b cle_so,
9948: okc_rules_b rul_so,
9949: okc_rule_groups_b rgp_so,

Line 9949: okc_rule_groups_b rgp_so,

9945: okc_rule_groups_b rgp_rv,
9946: okc_line_styles_b lse_so,
9947: okc_k_lines_b cle_so,
9948: okc_rules_b rul_so,
9949: okc_rule_groups_b rgp_so,
9950: okc_rule_groups_b rgp_pay,
9951: okc_rules_b rul_slh,
9952: okc_rules_b rul_sll,
9953: okl_strm_type_b sty

Line 9950: okc_rule_groups_b rgp_pay,

9946: okc_line_styles_b lse_so,
9947: okc_k_lines_b cle_so,
9948: okc_rules_b rul_so,
9949: okc_rule_groups_b rgp_so,
9950: okc_rule_groups_b rgp_pay,
9951: okc_rules_b rul_slh,
9952: okc_rules_b rul_sll,
9953: okl_strm_type_b sty
9954: WHERE rgp_so.cle_id = p_kle_id

Line 10049: okc_rule_groups_b rgp,

10045: okl_k_lines kle,
10046: okc_line_styles_b lse,
10047: okc_rules_b sll,
10048: okc_rules_b slh,
10049: okc_rule_groups_b rgp,
10050: okl_strm_type_b stm
10051: WHERE chr_so.id = p_khr_id
10052: and cle.sts_code in( 'COMPLETE', 'INCOMPLETE')--'ENTERED'
10053: AND cle.dnz_chr_id = chr_so.id

Line 10088: okc_rule_groups_b rgp,

10084: okl_k_lines kle,
10085: okc_line_styles_b lse,
10086: okc_rules_b sll,
10087: okc_rules_b slh,
10088: okc_rule_groups_b rgp,
10089: okl_strm_type_b stm
10090: WHERE chr_so.id = p_khr_id
10091: and cle.sts_code in( 'COMPLETE', 'INCOMPLETE')--'ENTERED'
10092: AND cle.dnz_chr_id = chr_so.id

Line 11147: okc_rule_groups_b rgp,

11143: NVL(sll.rule_information10, 'N') arrears_yn,
11144: FND_NUMBER.canonical_to_number(sll.rule_information6) rent_amount
11145: FROM okc_rules_b sll,
11146: okc_rules_b slh,
11147: okc_rule_groups_b rgp,
11148: okl_strm_type_b sty,
11149: okl_strm_type_tl styt
11150: WHERE rgp.dnz_chr_id = p_khr_id
11151: AND rgp.rgd_code= 'LALEVL'