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_ISG_UTILS_PVT dependencies on OKC_RULES_B

Line 604: OKC_RULES_B crl

600: crl.RULE_INFORMATION5,
601: crl.RULE_INFORMATION6,
602: crl.RULE_INFORMATION10
603: from OKC_RULE_GROUPS_B crg,
604: OKC_RULES_B crl
605: where crl.rgp_id = crg.id
606: and crg.RGD_CODE = 'LALEVL'
607: and crl.RULE_INFORMATION_CATEGORY = 'LASLH'
608: and crg.dnz_chr_id = chrId

Line 623: okc_rules_b rul

619:
620: CURSOR c_pt_perc( kleid NUMBER) IS
621: SELECT NVL(TO_NUMBER(rul.rule_information1), 100) pass_through_percentage
622: FROM okc_rule_groups_b rgp,
623: okc_rules_b rul
624: WHERE rgp.cle_id = kleid
625: AND rgp.rgd_code = 'LAPSTH'
626: AND rgp.id = rul.rgp_id
627: AND rul.rule_information_category = 'LAPTPR';

Line 634: FROM okc_rules_b rul,

630:
631: CURSOR c_rec_exp (p_khr_id NUMBER, p_kle_id NUMBER) IS
632: SELECT TO_NUMBER(rul.rule_information1) periods,
633: TO_NUMBER(rul.rule_information2) amount --,
634: FROM okc_rules_b rul,
635: okc_rules_b rul2,
636: okc_rule_groups_b rgp,
637: okc_k_lines_b cle,
638: okl_k_lines kle

Line 635: okc_rules_b rul2,

631: CURSOR c_rec_exp (p_khr_id NUMBER, p_kle_id NUMBER) IS
632: SELECT TO_NUMBER(rul.rule_information1) periods,
633: TO_NUMBER(rul.rule_information2) amount --,
634: FROM okc_rules_b rul,
635: okc_rules_b rul2,
636: okc_rule_groups_b rgp,
637: okc_k_lines_b cle,
638: okl_k_lines kle
639: WHERE rgp.dnz_chr_id = p_khr_id