APPS.OKL_GENERATE_ACCRUALS_PVT dependencies on OKL_STRM_TYPE_B

Line 375: FROM OKL_STRM_TYPE_B sty,

371: FROM OKC_K_HEADERS_B CHR
372: WHERE id = p_chr_id
373: AND EXISTS (
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,

Line 894: -- on okl_strm_type_b for bug# 2475123

890: ,p_accrual_rule_yn IN VARCHAR2) IS
891:
892:
893: -- modified cursor where clause and removed accrue_yn attribute check
894: -- on okl_strm_type_b for bug# 2475123
895: -- added sty.accrual_yn = 'Y' for ER 2872216.
896: CURSOR select_streams_csr(p_ctr_id NUMBER, p_accrue_from_date DATE, p_accrue_till_date DATE) IS
897: SELECT sty.id,
898: stytl.name,

Line 903: FROM OKL_STRM_TYPE_B sty,

899: stm.id stream_id,
900: ste.id stream_element_id,
901: ste.amount,
902: stm.kle_id
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,

Line 936: FROM OKL_STRM_TYPE_B sty,

932: stm.id stream_id,
933: ste.id stream_element_id,
934: ste.amount,
935: stm.kle_id
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,

Line 2267: FROM OKL_STRM_TYPE_B

2263:
2264: -- cursor to retrieve accrual rule value
2265: CURSOR accrual_rule_csr (p_sty_id NUMBER) IS
2266: SELECT accrual_yn
2267: FROM OKL_STRM_TYPE_B
2268: WHERE id = p_sty_id;
2269:
2270:
2271: BEGIN

Line 2894: FROM OKL_STRM_TYPE_B sty,

2890: SELECT sty.id sty_id,
2891: ste.id ste_id,
2892: ste.amount amount,
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,

Line 2930: FROM OKL_STRM_TYPE_B sty,

2926: SELECT sty.id sty_id,
2927: ste.id ste_id,
2928: ste.amount amount,
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,

Line 2967: FROM OKL_STRM_TYPE_B sty,

2963: SELECT sty.id sty_id,
2964: ste.id ste_id,
2965: ste.amount amount,
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,

Line 3004: FROM OKL_STRM_TYPE_B sty,

3000: SELECT sty.id sty_id,
3001: ste.id ste_id,
3002: ste.amount amount,
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,