DBA Data[Home] [Help]

APPS.OKL_EXPENSE_STREAMS_PVT dependencies on OKL_STRM_TYPE_B

Line 36: okl_strm_type_b sty,

32: SELECT sel.amount income_amount,
33: sel.stream_element_date income_date
34: FROM okl_strm_elements sel,
35: okl_streams stm,
36: okl_strm_type_b sty,
37: okl_strm_type_tl styt
38: WHERE stm.khr_id = p_khr_id
39: AND stm.say_code = 'WORK'
40: AND DECODE(stm.purpose_code, NULL, '-99', 'REPORT') = p_purpose_code

Line 84: okl_strm_type_b sty

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'
88: and slh.RULE_INFORMATION_CATEGORY = 'LASLH'