DBA Data[Home] [Help]

APPS.OKL_REPORT_GENERATOR_PVT dependencies on OKL_PROD_STRM_TYPES

Line 6011: FROM OKL_PROD_STRM_TYPES PSYY,

6007: --Cursor to fetch all accruable streams for a product
6008: CURSOR C_ALL_ACCRUABLE_STREAMS (p_pdt_id NUMBER)
6009: IS
6010: SELECT styy.id STY_ID
6011: FROM OKL_PROD_STRM_TYPES PSYY,
6012: OKL_STRM_TYPE_V STYY
6013: WHERE psyy.sty_id = styy.id
6014: AND psyy.accrual_yn = 'Y'
6015: AND psyy.pdt_id = p_pdt_id;

Line 6086: FROM OKL_PROD_STRM_TYPES PSYY,

6082: AND KH.ID = KHR.ID
6083: AND KH.PDT_ID = PRO.ID
6084: AND KHR.ORG_ID = OU.ORGANIZATION_ID
6085: AND STY.ID IN ( SELECT styy.id
6086: FROM OKL_PROD_STRM_TYPES PSYY,
6087: OKL_STRM_TYPE_V STYY
6088: WHERE psyy.sty_id = sty.id
6089: AND psyy.accrual_yn = 'Y'
6090: and psyy.pdt_id = KH.PDT_ID

Line 6174: FROM OKL_PROD_STRM_TYPES PSYY,

6170: AND KH.ID = KHR.ID
6171: AND KH.PDT_ID = PRO.ID
6172: AND KHR.ORG_ID = OU.ORGANIZATION_ID
6173: AND STY.ID IN ( SELECT styy.id
6174: FROM OKL_PROD_STRM_TYPES PSYY,
6175: OKL_STRM_TYPE_V STYY
6176: WHERE psyy.sty_id = sty.id
6177: AND psyy.accrual_yn = 'Y'
6178: and psyy.pdt_id = KH.PDT_ID