APPS.OKL_ACCRUAL_SEC_PVT dependencies on OKL_STRM_ELEMENTS

Line 268: FROM okl_strm_type_b sty, okl_streams stm, okl_strm_elements ste

264: end_date DATE,
265: l_stream_type_purpose VARCHAR2)
266: IS
267: select ste.stream_element_date stream_element_date,ste.amount amount
268: FROM okl_strm_type_b sty, okl_streams stm, okl_strm_elements ste
269: WHERE
270: stm.sty_id = sty.id
271: AND ste.stm_id = stm.id
272: AND stm.active_yn = 'Y'

Line 485: okl_strm_elements ste

481: /* l_stmt := 'SELECT ste.stream_element_date stream_element_date,
482: ste.amount amount
483: FROM okl_strm_type_b sty,
484: okl_streams stm,
485: okl_strm_elements ste
486: WHERE 1 = 1
487: AND stm.sty_id = sty.id
488: AND ste.stm_id = stm.id
489: AND stm.active_yn = '||''''||'Y'||''''||'

Line 1123: FROM okl_strm_type_b sty, okl_streams stm, okl_strm_elements ste

1119: p_end_date DATE,
1120: p_stream_type_purpose VARCHAR2)
1121: IS
1122: select ste.stream_element_date stream_element_date,ste.amount amount
1123: FROM okl_strm_type_b sty, okl_streams stm, okl_strm_elements ste
1124: WHERE
1125: stm.sty_id = sty.id
1126: AND ste.stm_id = stm.id
1127: AND stm.active_yn = 'Y'

Line 1278: ,OKL_STRM_ELEMENTS ste

1274: /*l_stmt := 'SELECT ste.stream_element_date stream_element_date
1275: ,ste.amount amount
1276: FROM OKL_STRM_TYPE_B sty
1277: ,OKL_STREAMS stm
1278: ,OKL_STRM_ELEMENTS ste
1279: WHERE 1 = 1
1280: AND stm.sty_id = sty.id
1281: AND ste.stm_id = stm.id
1282: AND stm.active_yn = '||''''||'Y'||''''||'

Line 1902: OKL_STRM_ELEMENTS ste

1898: CURSOR non_accrued_streams_csr(p_khr_id NUMBER, p_sty_code VARCHAR2, p_date DATE) IS
1899: SELECT ste.id
1900: FROM OKL_STRM_TYPE_B sty,
1901: OKL_STREAMS stm,
1902: OKL_STRM_ELEMENTS ste
1903: WHERE stm.khr_id = p_khr_id
1904: AND stm.sty_id = sty.id
1905: --AND sty.code = p_sty_code
1906: AND sty.stream_type_purpose = p_sty_code

Line 1917: OKL_STRM_ELEMENTS ste

1913: CURSOR accrued_streams_csr(p_khr_id NUMBER, p_sty_code VARCHAR2, p_date DATE) IS
1914: SELECT ste.id
1915: FROM OKL_STRM_TYPE_B sty,
1916: OKL_STREAMS stm,
1917: OKL_STRM_ELEMENTS ste
1918: WHERE stm.khr_id = p_khr_id
1919: AND stm.sty_id = sty.id
1920: --AND sty.code = p_sty_code
1921: AND sty.stream_type_purpose = p_sty_code

Line 2155: okl_strm_elements ste,

2151: sum(ste.amount) amount,
2152: str.sty_id sty_id
2153: --FROM okl_streams str,
2154: FROM okl_streams_rep_v str, -- MGAAP 7263041
2155: okl_strm_elements ste,
2156: okl_strm_type_b sty
2157: WHERE ste.stm_id = str.id
2158: AND str.sty_id = sty.id
2159: AND str.say_code = 'CURR'

Line 2173: okl_strm_elements ste,

2169: sum(ste.amount) amount,
2170: str.sty_id sty_id
2171: --FROM okl_streams str,
2172: FROM okl_streams_rep_v str, -- MGAAP 7263041
2173: okl_strm_elements ste,
2174: okl_strm_type_b sty
2175: WHERE ste.stm_id = str.id
2176: AND str.sty_id = sty.id
2177: AND str.say_code = 'CURR'

Line 2191: okl_strm_elements ste,

2187: SELECT
2188: sum(ste.amount)
2189: --FROM okl_streams str,
2190: FROM okl_streams_rep_v str, -- MGAAP 7263041
2191: okl_strm_elements ste,
2192: okl_strm_type_b sty
2193: WHERE ste.stm_id = str.id
2194: AND str.sty_id = sty.id
2195: AND str.say_code = 'CURR'

Line 2207: okl_strm_elements ste,

2203: SELECT
2204: sum(ste.amount)
2205: --FROM okl_streams str,
2206: FROM okl_streams_rep_v str, -- MGAAP 7263041
2207: okl_strm_elements ste,
2208: okl_strm_type_b sty
2209: WHERE ste.stm_id = str.id
2210: AND str.sty_id = sty.id
2211: AND str.say_code = 'CURR'