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 2326: okc_rules_v cr

2322: and cpl.object1_id2 = '#'
2323: -- Pass through check
2324: and not exists (select null
2325: from okc_rule_groups_v crg,
2326: okc_rules_v cr
2327: where crg.dnz_chr_id = p_contract_id
2328: and crg.cle_id = cle.id -- line id for rle_code
2329: and crg.id = cr.rgp_id
2330: and crg.rgd_code = 'LAPSTH')

Line 2356: okc_rules_v cr,

2352: , months_between(trunc(p_due_date), nvl(cle.start_date, k.start_date))))
2353: --cklee end 10/3/2007 bug: 6128765
2354:
2355: from okc_rule_groups_v crg,
2356: okc_rules_v cr,
2357: OKL_K_LINES_FULL_V cle,
2358: okc_k_headers_b k
2359: where crg.dnz_chr_id = p_contract_id
2360: and cle.dnz_chr_id = k.id

Line 2378: okc_rules_v cr

2374: IS
2375: select to_number(nvl(cr.RULE_INFORMATION1,'0'))
2376: ,to_number(nvl(cr.RULE_INFORMATION2,'0'))
2377: from okc_rule_groups_v crg,
2378: okc_rules_v cr
2379: where crg.dnz_chr_id = p_contract_id
2380: and crg.id = cr.rgp_id
2381:
2382: and crg.rgd_code = 'LAFEXP'

Line 2564: okc_rules_v cr

2560: --and cpl.object1_id2 = '#'
2561: -- Pass through check
2562: and not exists (select null
2563: from okc_rule_groups_v crg,
2564: okc_rules_v cr
2565: where crg.dnz_chr_id = p_contract_id
2566: and crg.cle_id = cle.id -- line id for rle_code
2567: and crg.id = cr.rgp_id
2568: and crg.rgd_code = 'LAPSTH')

Line 2593: okc_rules_v cr,

2589: , 'S', months_between(trunc(p_due_date), nvl(cle.start_date, k.start_date))/6
2590: , months_between(trunc(p_due_date), nvl(cle.start_date, k.start_date))))
2591: --cklee end 10/3/2007 bug: 6128765
2592: from okc_rule_groups_v crg,
2593: okc_rules_v cr,
2594: OKL_K_LINES_FULL_V cle,
2595: okc_k_headers_b k
2596: where crg.dnz_chr_id = p_contract_id
2597: and cle.dnz_chr_id = k.id

Line 2615: okc_rules_v cr

2611: IS
2612: select to_number(nvl(cr.RULE_INFORMATION1,'0'))
2613: ,to_number(nvl(cr.RULE_INFORMATION2,'0'))
2614: from okc_rule_groups_v crg,
2615: okc_rules_v cr
2616: where crg.dnz_chr_id = p_contract_id
2617: and crg.id = cr.rgp_id
2618: and crg.rgd_code = 'LAFEXP'
2619: and cr.RULE_INFORMATION_CATEGORY = 'LAFEXP'

Line 8492: okc_rules_v cr

8488: --and cpl.object1_id2 = '#'
8489: -- Pass through check
8490: and not exists (select null
8491: from okc_rule_groups_v crg,
8492: okc_rules_v cr
8493: where crg.dnz_chr_id = p_contract_id
8494: and crg.cle_id = cle.id -- line id for rle_code
8495: and crg.id = cr.rgp_id
8496: and crg.rgd_code = 'LAPSTH')

Line 8516: okc_rules_v cr,

8512: , 'Q', months_between(p_effective_date, nvl(cle.start_date, k.start_date))/3
8513: , 'S', months_between(p_effective_date, nvl(cle.start_date, k.start_date))/6
8514: , months_between(p_effective_date, nvl(cle.start_date, k.start_date))))
8515: from okc_rule_groups_v crg,
8516: okc_rules_v cr,
8517: OKL_K_LINES_FULL_V cle,
8518: okc_k_headers_b k
8519: where crg.dnz_chr_id = p_contract_id
8520: and cle.dnz_chr_id = k.id

Line 8538: okc_rules_v cr

8534: IS
8535: select to_number(nvl(cr.RULE_INFORMATION1,'0'))
8536: ,to_number(nvl(cr.RULE_INFORMATION2,'0'))
8537: from okc_rule_groups_v crg,
8538: okc_rules_v cr
8539: where crg.dnz_chr_id = p_contract_id
8540: and crg.id = cr.rgp_id
8541: and crg.rgd_code = 'LAFEXP'
8542: and cr.RULE_INFORMATION_CATEGORY = 'LAFEXP'