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 1271: FROM okc_rules_b sll,

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

Line 1272: okc_rules_b slh,

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

Line 1346: okc_rules_b crl

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

Line 1445: FROM okc_rules_b sll,

1441: l_sty_id NUMBER;
1442:
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

Line 1446: okc_rules_b slh,

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

Line 2326: okc_rules_b rul_slh,

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

Line 2327: okc_rules_b rul_sll,

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

Line 2900: okc_rules_b sll,

2896: okc_k_headers_b chr_so,
2897: okc_k_lines_b cle,
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

Line 2901: okc_rules_b slh,

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

Line 2952: okc_rules_b sll,

2948: okc_k_headers_b chr_so,
2949: okc_k_lines_b cle,
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

Line 2953: okc_rules_b slh,

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

Line 3003: okc_rules_b sll,

2999: okl_strm_elements sel_amt,
3000: okc_k_headers_b chr_so,
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

Line 3004: okc_rules_b slh,

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

Line 3041: okc_rules_b rul_slh,

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

Line 3042: okc_rules_b rul_sll,

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

Line 3081: okc_rules_b rul,

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

Line 3082: okc_rules_b rul2

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

Line 3116: okc_rules_b sll,

3112: okc_k_headers_b chr_so,
3113: okc_k_lines_b cle,
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

Line 3117: okc_rules_b slh,

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

Line 3120: okc_rules_b laptpr

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

Line 3156: FROM okc_rules_b rul,

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

Line 3157: okc_rules_b rul2,

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

Line 4225: okc_rules_b sll,

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

Line 4226: okc_rules_b slh,

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

Line 4248: OKC_RULES_B crl,

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

Line 4278: okc_rules_b sll,

4274: okl_strm_type_b sty,
4275: okl_strm_elements sel,
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'

Line 4279: okc_rules_b slh,

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

Line 4321: okc_rules_b slh,

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

Line 4322: okc_rules_b sll,

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

Line 4340: FROM okc_rules_b

4336: AND styt.stream_type_purpose = 'RENT';
4337:
4338: CURSOR c_deposit_date IS
4339: SELECT FND_DATE.canonical_to_date(rule_information5)
4340: FROM okc_rules_b
4341: WHERE dnz_chr_id = p_khr_id
4342: AND rule_information_category = 'LASDEP';
4343:
4344: /* CURSOR c_asset_cost IS

Line 4376: okc_rules_b slh,

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

Line 4377: okc_rules_b sll,

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

Line 4421: okc_rules_b rul,

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

Line 4422: okc_rules_b rul2

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

Line 4449: okc_rules_b sll,

4445: okl_strm_type_b sty,
4446: okl_strm_elements sel,
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

Line 4450: okc_rules_b slh,

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

Line 4453: okc_rules_b laptpr

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

Line 4483: FROM okc_rules_b rul,

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

Line 4484: okc_rules_b rul2,

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

Line 5844: FROM okc_rules_b sll,

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

Line 5845: okc_rules_b slh,

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

Line 6335: okc_rules_b sll,

6331: okl_strm_elements sel_amt,
6332: okc_k_headers_b chr_so,
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

Line 6336: okc_rules_b slh,

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

Line 6373: okc_rules_b rul_slh,

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

Line 6374: okc_rules_b rul_sll,

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

Line 7050: okc_rules_b rul_rv,

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

Line 7054: okc_rules_b rul_so,

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,
7056: okc_rule_groups_b rgp_pay,
7057: okc_rules_b rul_slh,
7058: okc_rules_b rul_sll,

Line 7057: okc_rules_b rul_slh,

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

Line 7058: okc_rules_b rul_sll,

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

Line 7155: okc_rules_b sll,

7151: FROM okc_k_headers_b chr_so,
7152: okc_k_lines_b cle,
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

Line 7156: okc_rules_b slh,

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

Line 7759: okc_rules_b slh,

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

Line 7760: okc_rules_b sll,

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

Line 8160: okc_rules_b sll,

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

Line 8161: okc_rules_b slh,

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

Line 8183: OKC_RULES_B crl,

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

Line 8211: okc_rules_b sll,

8207: okl_strm_type_b sty,
8208: okl_strm_elements sel,
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'

Line 8212: okc_rules_b slh,

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

Line 8256: okc_rules_b sll,

8252: okl_strm_elements sel,
8253: okc_k_lines_b cle,
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'

Line 8257: okc_rules_b slh,

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

Line 8302: okc_rules_b slh,

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

Line 8303: okc_rules_b sll,

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

Line 8321: FROM okc_rules_b

8317: AND sty.stream_type_purpose = 'RENT';
8318:
8319: CURSOR c_deposit_date IS
8320: SELECT FND_DATE.canonical_to_date(rule_information5)
8321: FROM okc_rules_b
8322: WHERE dnz_chr_id = p_khr_id
8323: AND rule_information_category = 'LASDEP';
8324:
8325: /* CURSOR c_asset_cost IS

Line 8357: okc_rules_b slh,

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

Line 8358: okc_rules_b sll,

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

Line 8402: okc_rules_b rul,

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

Line 8403: okc_rules_b rul2

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

Line 8424: FROM okc_rules_b rul,

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

Line 8425: okc_rules_b rul2,

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

Line 9559: okc_rules_b rul_rv,

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

Line 9563: okc_rules_b rul_so,

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,
9565: okc_rule_groups_b rgp_pay,
9566: okc_rules_b rul_slh,
9567: okc_rules_b rul_sll,

Line 9566: okc_rules_b rul_slh,

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

Line 9567: okc_rules_b rul_sll,

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

Line 9662: okc_rules_b sll,

9658: FROM okc_k_headers_b chr_so,
9659: okc_k_lines_b cle,
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

Line 9663: okc_rules_b slh,

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

Line 9701: okc_rules_b sll,

9697: FROM okc_k_headers_b chr_so,
9698: okc_k_lines_b cle,
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

Line 9702: okc_rules_b slh,

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

Line 10767: FROM okc_rules_b sll,

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

Line 10768: okc_rules_b slh,

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