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

Line 319: FROM OKC_RULES_B

315: RGD_CODE = P_RGD_CODE;
316:
317: cursor RULE_CSR(P_RUL_ID IN NUMBER) is
318: SELECT RULE_INFORMATION1
319: FROM OKC_RULES_B
320: WHERE ID = P_RUL_ID;
321:
322: cursor RLE_CSR(P_CPL_ID IN VARCHAR2) is
323: SELECT RLE_CODE

Line 523: FROM OKC_RULES_B

519: lp_vrs_rulv_rec Okl_Rule_Pub.rulv_rec_type;
520:
521: cursor RULE_CSR(P_RUL_ID IN NUMBER) is
522: SELECT RULE_INFORMATION1
523: FROM OKC_RULES_B
524: WHERE ID = P_RUL_ID;
525:
526: cursor RLE_CSR(P_CPL_ID IN VARCHAR2) is
527: SELECT RLE_CODE

Line 633: FROM OKC_RULES_B rul,

629: l_percent NUMBER;
630:
631: cursor RESI_PERCENT_CSR is
632: SELECT sum(to_number(nvl(RULE_INFORMATION2,0)))
633: FROM OKC_RULES_B rul,
634: okc_rule_groups_b rgp
635: WHERE rgp.ID = rul.rgp_id
636: AND rgp.dnz_chr_id = rul.dnz_chr_id
637: AND rgp.chr_id = p_chr_id;