APPS.OKL_FUNDING_PVT dependencies on OKC_RULE_GROUPS_V

Line 2352: from okc_rule_groups_v crg,

2348: and cpl.object1_id1 = to_char(p_vendor_id)
2349: and cpl.object1_id2 = '#'
2350: -- Pass through check
2351: /* and not exists (select null
2352: from okc_rule_groups_v crg,
2353: okc_rules_v cr
2354: where crg.dnz_chr_id = p_contract_id
2355: and crg.cle_id = cle.id -- line id for rle_code
2356: and crg.id = cr.rgp_id

Line 2410: from okc_rule_groups_v crg,

2406: , 'S', months_between(trunc(p_due_date), nvl(cle.start_date, k.start_date))/6
2407: , months_between(trunc(p_due_date), nvl(cle.start_date, k.start_date))))
2408: --cklee end 10/3/2007 bug: 6128765
2409:
2410: from okc_rule_groups_v crg,
2411: okc_rules_v cr,
2412: OKL_K_LINES_FULL_V cle,
2413: okc_k_headers_b k
2414: where crg.dnz_chr_id = p_contract_id

Line 2432: from okc_rule_groups_v crg,

2428: CURSOR c_amount_per (p_contract_id NUMBER, p_cle_id NUMBER)
2429: IS
2430: select to_number(nvl(cr.RULE_INFORMATION1,'0'))
2431: ,to_number(nvl(cr.RULE_INFORMATION2,'0'))
2432: from okc_rule_groups_v crg,
2433: okc_rules_v cr
2434: where crg.dnz_chr_id = p_contract_id
2435: and crg.id = cr.rgp_id
2436:

Line 2632: from okc_rule_groups_v crg,

2628: --and cpl.object1_id2 = '#'
2629: -- Pass through check
2630: /*
2631: and not exists (select null
2632: from okc_rule_groups_v crg,
2633: okc_rules_v cr
2634: where crg.dnz_chr_id = p_contract_id
2635: and crg.cle_id = cle.id -- line id for rle_code
2636: and crg.id = cr.rgp_id

Line 2690: from okc_rule_groups_v crg,

2686: , 'Q', months_between(trunc(p_due_date), nvl(cle.start_date, k.start_date))/3
2687: , 'S', months_between(trunc(p_due_date), nvl(cle.start_date, k.start_date))/6
2688: , months_between(trunc(p_due_date), nvl(cle.start_date, k.start_date))))
2689: --cklee end 10/3/2007 bug: 6128765
2690: from okc_rule_groups_v crg,
2691: okc_rules_v cr,
2692: OKL_K_LINES_FULL_V cle,
2693: okc_k_headers_b k
2694: where crg.dnz_chr_id = p_contract_id

Line 2712: from okc_rule_groups_v crg,

2708: CURSOR c_amount_per (p_contract_id NUMBER, p_cle_id NUMBER)
2709: IS
2710: select to_number(nvl(cr.RULE_INFORMATION1,'0'))
2711: ,to_number(nvl(cr.RULE_INFORMATION2,'0'))
2712: from okc_rule_groups_v crg,
2713: okc_rules_v cr
2714: where crg.dnz_chr_id = p_contract_id
2715: and crg.id = cr.rgp_id
2716: and crg.rgd_code = 'LAFEXP'

Line 8709: from okc_rule_groups_v crg,

8705: --and cpl.object1_id2 = '#'
8706: -- Pass through check
8707: /*
8708: and not exists (select null
8709: from okc_rule_groups_v crg,
8710: okc_rules_v cr
8711: where crg.dnz_chr_id = p_contract_id
8712: and crg.cle_id = cle.id -- line id for rle_code
8713: and crg.id = cr.rgp_id

Line 8737: from okc_rule_groups_v crg,

8733: , 'M', months_between(p_effective_date, nvl(cle.start_date, k.start_date))
8734: , 'Q', months_between(p_effective_date, nvl(cle.start_date, k.start_date))/3
8735: , 'S', months_between(p_effective_date, nvl(cle.start_date, k.start_date))/6
8736: , months_between(p_effective_date, nvl(cle.start_date, k.start_date))))
8737: from okc_rule_groups_v crg,
8738: okc_rules_v cr,
8739: OKL_K_LINES_FULL_V cle,
8740: okc_k_headers_b k
8741: where crg.dnz_chr_id = p_contract_id

Line 8759: from okc_rule_groups_v crg,

8755: p_cle_id NUMBER)
8756: IS
8757: select to_number(nvl(cr.RULE_INFORMATION1,'0'))
8758: ,to_number(nvl(cr.RULE_INFORMATION2,'0'))
8759: from okc_rule_groups_v crg,
8760: okc_rules_v cr
8761: where crg.dnz_chr_id = p_contract_id
8762: and crg.id = cr.rgp_id
8763: and crg.rgd_code = 'LAFEXP'