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

Line 82: OKC_RULES_B sll,

78:
79: Cursor c_rollover_pmnts IS
80: Select distinct nvl(slh.object1_id1, -1) styId
81: From OKC_RULE_GROUPS_B rgp,
82: OKC_RULES_B sll,
83: okc_rules_b slh,
84: okl_strm_type_b sty
85: Where slh.rgp_id = rgp.id
86: and rgp.RGD_CODE = 'LALEVL'

Line 83: okc_rules_b slh,

79: Cursor c_rollover_pmnts IS
80: Select distinct nvl(slh.object1_id1, -1) styId
81: From OKC_RULE_GROUPS_B rgp,
82: OKC_RULES_B sll,
83: okc_rules_b slh,
84: okl_strm_type_b sty
85: Where slh.rgp_id = rgp.id
86: and rgp.RGD_CODE = 'LALEVL'
87: and sll.RULE_INFORMATION_CATEGORY = 'LASLL'

Line 379: FROM okc_rules_b rul,

375: DECODE(rul2.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12, NULL) mpp,
376: rgp.cle_id,
377: cle.start_date,
378: cle.sts_code
379: FROM okc_rules_b rul,
380: okc_rules_b rul2,
381: okc_rule_groups_b rgp,
382: okc_k_lines_b cle,
383: okl_k_lines kle

Line 380: okc_rules_b rul2,

376: rgp.cle_id,
377: cle.start_date,
378: cle.sts_code
379: FROM okc_rules_b rul,
380: okc_rules_b rul2,
381: okc_rule_groups_b rgp,
382: okc_k_lines_b cle,
383: okl_k_lines kle
384: WHERE rgp.dnz_chr_id = p_khr_id