APPS.OKL_GENERATE_ACCRUALS_PVT dependencies on OKL_STRM_ELEMENTS

Line 117: OKL_STRM_ELEMENTS ste

113:
114: CURSOR get_unb_rec_csr(p_sty_id NUMBER) IS
115: SELECT NVL(SUM(ste.amount),0)
116: FROM OKL_STREAMS stm,
117: OKL_STRM_ELEMENTS ste
118: WHERE stm.khr_id = p_ctr_id
119: AND stm.sty_id = p_sty_id
120: AND stm.active_yn = 'Y'
121: AND ste.stm_id = stm.id

Line 378: OKL_STRM_ELEMENTS ste,

374: SELECT 1
375: FROM OKL_STRM_TYPE_B sty,
376: --OKL_STREAMS stm,
377: OKL_STREAMS_REP_V stm, -- MGAAP 7263041
378: OKL_STRM_ELEMENTS ste,
379: OKL_PROD_STRM_TYPES psty,
380: OKL_K_HEADERS khr,
381: OKL_PRODUCTS pdt
382: WHERE khr.id = p_chr_id

Line 907: OKL_STRM_ELEMENTS ste,

903: FROM OKL_STRM_TYPE_B sty,
904: OKL_STRM_TYPE_TL stytl,
905: --OKL_STREAMS stm,
906: OKL_STREAMS_REP_V stm, -- MGAAP 7263041
907: OKL_STRM_ELEMENTS ste,
908: OKL_PROD_STRM_TYPES psty,
909: OKL_K_HEADERS khr
910: WHERE stm.khr_id = p_ctr_id
911: AND khr.id = stm.khr_id

Line 940: OKL_STRM_ELEMENTS ste,

936: FROM OKL_STRM_TYPE_B sty,
937: OKL_STRM_TYPE_TL stytl,
938: --OKL_STREAMS stm,
939: OKL_STREAMS_REP_V stm, -- MGAAP 7263041
940: OKL_STRM_ELEMENTS ste,
941: OKL_PROD_STRM_TYPES psty,
942: OKL_K_HEADERS khr
943: WHERE stm.khr_id = p_ctr_id
944: AND khr.id = stm.khr_id

Line 2057: UPDATE okl_strm_elements

2053: END LOOP;
2054:
2055: -- Do bulk update
2056: FORALL i IN l_selv_tbl.FIRST..l_selv_tbl.LAST
2057: UPDATE okl_strm_elements
2058: SET accrued_yn = 'Y' where id = l_selv_tbl(i);
2059:
2060: --
2061: -- Bug 4662173. Commenting below call for performance reasons.

Line 2764: ste_id OKL_STRM_ELEMENTS_V.ID%TYPE,

2760: -- local collections
2761: TYPE accelerate_ref_cursor IS REF CURSOR;
2762: TYPE stream_rec IS RECORD
2763: (sty_id OKL_STRM_TYPE_V.ID%TYPE,
2764: ste_id OKL_STRM_ELEMENTS_V.ID%TYPE,
2765: amount NUMBER,
2766: kle_id OKL_STREAMS.kle_ID%TYPE);
2767:
2768: --local variables

Line 2897: OKL_STRM_ELEMENTS ste,

2893: stm.kle_id
2894: FROM OKL_STRM_TYPE_B sty,
2895: --OKL_STREAMS stm,
2896: OKL_STREAMS_REP_V stm, --MGAAP 7263041
2897: OKL_STRM_ELEMENTS ste,
2898: OKL_PROD_STRM_TYPES psty,
2899: OKL_K_HEADERS khr,
2900: OKL_PRODUCTS pdt
2901: WHERE sty.id = p_acceleration_rec.sty_id

Line 2933: OKL_STRM_ELEMENTS ste,

2929: stm.kle_id
2930: FROM OKL_STRM_TYPE_B sty,
2931: --OKL_STREAMS stm,
2932: OKL_STREAMS_REP_V stm, --MGAAP 7263041
2933: OKL_STRM_ELEMENTS ste,
2934: OKL_PROD_STRM_TYPES psty,
2935: OKL_K_HEADERS khr,
2936: OKL_PRODUCTS pdt
2937: WHERE sty.id = p_acceleration_rec.sty_id

Line 2970: OKL_STRM_ELEMENTS ste,

2966: stm.kle_id
2967: FROM OKL_STRM_TYPE_B sty,
2968: --OKL_STREAMS stm,
2969: OKL_STREAMS_REP_V stm, --MGAAP 7263041
2970: OKL_STRM_ELEMENTS ste,
2971: OKL_PROD_STRM_TYPES psty,
2972: OKL_K_HEADERS khr,
2973: OKL_PRODUCTS pdt
2974: WHERE stm.khr_id = p_acceleration_rec.khr_id

Line 3007: OKL_STRM_ELEMENTS ste,

3003: stm.kle_id
3004: FROM OKL_STRM_TYPE_B sty,
3005: --OKL_STREAMS stm,
3006: OKL_STREAMS_REP_V stm, --MGAAP 7263041
3007: OKL_STRM_ELEMENTS ste,
3008: OKL_PROD_STRM_TYPES psty,
3009: OKL_K_HEADERS khr,
3010: OKL_PRODUCTS pdt
3011: WHERE stm.khr_id = p_acceleration_rec.khr_id