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_FUNDING_PVT dependencies on OKC_RULES_V

Line 2353: okc_rules_v cr

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
2357: and crg.rgd_code = 'LAPSTH') */

Line 2411: okc_rules_v cr,

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
2415: and cle.dnz_chr_id = k.id

Line 2433: okc_rules_v cr

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:
2437: and crg.rgd_code = 'LAFEXP'

Line 2633: okc_rules_v cr

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
2637: and crg.rgd_code = 'LAPSTH') */

Line 2691: okc_rules_v cr,

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
2695: and cle.dnz_chr_id = k.id

Line 2713: okc_rules_v cr

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'
2717: and cr.RULE_INFORMATION_CATEGORY = 'LAFEXP'

Line 8710: okc_rules_v cr

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
8714: and crg.rgd_code = 'LAPSTH') */

Line 8738: okc_rules_v cr,

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
8742: and cle.dnz_chr_id = k.id

Line 8760: okc_rules_v cr

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'
8764: and cr.RULE_INFORMATION_CATEGORY = 'LAFEXP'