APPS.OKL_PRICING_PVT dependencies on OKC_RULES_B

Line 177: FROM okc_rules_b sll,

173: DECODE(sll.object1_id1, 'M', 30, 'Q', 120, 'S', 180, 'A', 360) dpp,
174: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) mpp,
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

Line 178: okc_rules_b slh,

174: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) mpp,
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

Line 238: okc_rules_b crl

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'
242: AND crg.dnz_chr_id = p_khr_id

Line 319: FROM okc_rules_b sll,

315: l_stream_name VARCHAR2(256);
316:
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

Line 320: okc_rules_b slh,

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

Line 1264: FROM okc_rules_b sll,

1260: DECODE(sll.object1_id1, 'M', 30, 'Q', 120, 'S', 180, 'A', 360) dpp,
1261: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) mpp,
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

Line 1265: okc_rules_b slh,

1261: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) mpp,
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

Line 1333: okc_rules_b crl

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'
1337: AND crg.dnz_chr_id = p_khr_id

Line 1430: FROM okc_rules_b sll,

1426: l_sty_id NUMBER;
1427:
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

Line 1431: okc_rules_b slh,

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

Line 2726: okc_rules_b rul_slh,

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
2730: AND cle_so.dnz_chr_id = p_khr_id

Line 2727: okc_rules_b rul_sll,

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
2730: AND cle_so.dnz_chr_id = p_khr_id
2731: AND cle_so.lse_id = lse_so.id

Line 3300: okc_rules_b sll,

3296: okc_k_headers_b chr_so,
3297: okc_k_lines_b cle,
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

Line 3301: okc_rules_b slh,

3297: okc_k_lines_b cle,
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'

Line 3352: okc_rules_b sll,

3348: okc_k_headers_b chr_so,
3349: okc_k_lines_b cle,
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

Line 3353: okc_rules_b slh,

3349: okc_k_lines_b cle,
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

Line 3403: okc_rules_b sll,

3399: okl_strm_elements sel_amt,
3400: okc_k_headers_b chr_so,
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

Line 3404: okc_rules_b slh,

3400: okc_k_headers_b chr_so,
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

Line 3441: okc_rules_b rul_slh,

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
3445: AND cle_so.dnz_chr_id = p_khr_id

Line 3442: okc_rules_b rul_sll,

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
3445: AND cle_so.dnz_chr_id = p_khr_id
3446: AND cle_so.lse_id = lse_so.id

Line 3481: okc_rules_b rul,

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'
3485: AND rgp.id = rul.rgp_id

Line 3482: okc_rules_b rul2

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'
3485: AND rgp.id = rul.rgp_id
3486: AND rgp.id = rul2.rgp_id

Line 3516: okc_rules_b sll,

3512: okc_k_headers_b chr_so,
3513: okc_k_lines_b cle,
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

Line 3517: okc_rules_b slh,

3513: okc_k_lines_b cle,
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

Line 3520: okc_rules_b laptpr

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'
3524: AND stm.sty_id = sty.id

Line 3556: FROM okc_rules_b rul,

3552: DECODE(rul2.object1_id1, 'M', 30, 'Q', 90, 'S', 180, 'A', 360) cf_dpp,
3553: DECODE(rul2.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) cf_ppy,
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,

Line 3557: okc_rules_b rul2,

3553: DECODE(rul2.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) cf_ppy,
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

Line 4625: okc_rules_b sll,

4621: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year
4622: FROM okl_streams stm,
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'

Line 4626: okc_rules_b slh,

4622: FROM okl_streams stm,
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

Line 4648: OKC_RULES_B crl,

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
4652: and crg.RGD_CODE = 'LALEVL'

Line 4678: okc_rules_b sll,

4674: okl_strm_type_b sty,
4675: okl_strm_elements sel,
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'

Line 4679: okc_rules_b slh,

4675: okl_strm_elements sel,
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

Line 4721: okc_rules_b slh,

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
4725: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED')

Line 4722: okc_rules_b sll,

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
4725: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED')
4726: AND cle.lse_id = lse.id

Line 4740: FROM okc_rules_b

4736: AND styt.stream_type_purpose = 'RENT';
4737:
4738: CURSOR c_deposit_date IS
4739: SELECT FND_DATE.canonical_to_date(rule_information5)
4740: FROM okc_rules_b
4741: WHERE dnz_chr_id = p_khr_id
4742: AND rule_information_category = 'LASDEP';
4743:
4744: /* CURSOR c_asset_cost IS

Line 4776: okc_rules_b slh,

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
4780: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED') -- Bug 5011438

Line 4777: okc_rules_b sll,

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
4780: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED') -- Bug 5011438
4781: AND cle.lse_id = lse.id

Line 4821: okc_rules_b rul,

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'
4825: AND rgp.id = rul.rgp_id

Line 4822: okc_rules_b rul2

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'
4825: AND rgp.id = rul.rgp_id
4826: AND rgp.id = rul2.rgp_id

Line 4849: okc_rules_b sll,

4845: okl_strm_type_b sty,
4846: okl_strm_elements sel,
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

Line 4850: okc_rules_b slh,

4846: okl_strm_elements sel,
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

Line 4853: okc_rules_b laptpr

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
4857: AND stm.sty_id = sty.id

Line 4883: FROM okc_rules_b rul,

4879: DECODE(rul2.object1_id1, 'M', 30, 'Q', 90, 'S', 180, 'A', 360) cf_dpp,
4880: DECODE(rul2.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) cf_ppy,
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

Line 4884: okc_rules_b rul2,

4880: DECODE(rul2.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) cf_ppy,
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

Line 6234: FROM okc_rules_b sll,

6230: DECODE(sll.object1_id1, 'M', 30, 'Q', 120, 'S', 180, 'A', 360) dpp,
6231: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) mpp,
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

Line 6235: okc_rules_b slh,

6231: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) mpp,
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

Line 6725: okc_rules_b sll,

6721: okl_strm_elements sel_amt,
6722: okc_k_headers_b chr_so,
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

Line 6726: okc_rules_b slh,

6722: okc_k_headers_b chr_so,
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

Line 6763: okc_rules_b rul_slh,

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
6767: AND cle_so.dnz_chr_id = p_khr_id

Line 6764: okc_rules_b rul_sll,

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
6767: AND cle_so.dnz_chr_id = p_khr_id
6768: AND cle_so.lse_id = lse_so.id

Line 7440: okc_rules_b rul_rv,

7436: cle_so.start_date
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,

Line 7444: okc_rules_b rul_so,

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,
7446: okc_rule_groups_b rgp_pay,
7447: okc_rules_b rul_slh,
7448: okc_rules_b rul_sll,

Line 7447: okc_rules_b rul_slh,

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
7451: AND rgp_so.dnz_chr_id = p_khr_id

Line 7448: okc_rules_b rul_sll,

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
7451: AND rgp_so.dnz_chr_id = p_khr_id
7452: AND rgp_so.rgd_code = 'SOPYSC'

Line 7545: okc_rules_b sll,

7541: FROM okc_k_headers_b chr_so,
7542: okc_k_lines_b cle,
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

Line 7546: okc_rules_b slh,

7542: okc_k_lines_b cle,
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'

Line 8149: okc_rules_b slh,

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
8153: AND cle.sts_code in ( 'BOOKED', 'TERMINATED' )

Line 8150: okc_rules_b sll,

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
8153: AND cle.sts_code in ( 'BOOKED', 'TERMINATED' )
8154: AND cle.lse_id = lse.id

Line 8550: okc_rules_b sll,

8546: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year
8547: FROM okl_streams stm,
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'

Line 8551: okc_rules_b slh,

8547: FROM okl_streams stm,
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

Line 8573: OKC_RULES_B crl,

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
8577: and crg.RGD_CODE = 'LALEVL'

Line 8601: okc_rules_b sll,

8597: okl_strm_type_b sty,
8598: okl_strm_elements sel,
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'

Line 8602: okc_rules_b slh,

8598: okl_strm_elements sel,
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

Line 8646: okc_rules_b sll,

8642: okl_strm_elements sel,
8643: okc_k_lines_b cle,
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'

Line 8647: okc_rules_b slh,

8643: okc_k_lines_b cle,
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

Line 8692: okc_rules_b slh,

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
8696: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED') -- Bug 5011438

Line 8693: okc_rules_b sll,

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
8696: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED') -- Bug 5011438
8697: AND cle.lse_id = lse.id

Line 8711: FROM okc_rules_b

8707: AND sty.stream_type_purpose = 'RENT';
8708:
8709: CURSOR c_deposit_date IS
8710: SELECT FND_DATE.canonical_to_date(rule_information5)
8711: FROM okc_rules_b
8712: WHERE dnz_chr_id = p_khr_id
8713: AND rule_information_category = 'LASDEP';
8714:
8715: /* CURSOR c_asset_cost IS

Line 8747: okc_rules_b slh,

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
8751: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED') -- Bug 5011438

Line 8748: okc_rules_b sll,

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
8751: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED') -- Bug 5011438
8752: AND cle.lse_id = lse.id

Line 8792: okc_rules_b rul,

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'
8796: AND rgp.id = rul.rgp_id

Line 8793: okc_rules_b rul2

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'
8796: AND rgp.id = rul.rgp_id
8797: AND rgp.id = rul2.rgp_id

Line 8814: FROM okc_rules_b rul,

8810: DECODE(rul2.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) cf_ppy,
8811: DECODE(rul2.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) cf_mpp,
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,

Line 8815: okc_rules_b rul2,

8811: DECODE(rul2.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) cf_mpp,
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

Line 9944: okc_rules_b rul_rv,

9940: cle_so.start_date
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,

Line 9948: okc_rules_b rul_so,

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,
9950: okc_rule_groups_b rgp_pay,
9951: okc_rules_b rul_slh,
9952: okc_rules_b rul_sll,

Line 9951: okc_rules_b rul_slh,

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
9955: AND rgp_so.dnz_chr_id = p_khr_id

Line 9952: okc_rules_b rul_sll,

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
9955: AND rgp_so.dnz_chr_id = p_khr_id
9956: AND rgp_so.rgd_code = 'SOPYSC'

Line 10047: okc_rules_b sll,

10043: FROM okc_k_headers_b chr_so,
10044: okc_k_lines_b cle,
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

Line 10048: okc_rules_b slh,

10044: okc_k_lines_b cle,
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'

Line 10086: okc_rules_b sll,

10082: FROM okc_k_headers_b chr_so,
10083: okc_k_lines_b cle,
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

Line 10087: okc_rules_b slh,

10083: okc_k_lines_b cle,
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'

Line 11145: FROM okc_rules_b sll,

11141: DECODE(sll.object1_id1, 'M', 30, 'Q', 120, 'S', 180, 'A', 360) dpp,
11142: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) mpp,
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

Line 11146: okc_rules_b slh,

11142: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) mpp,
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