APPS.OKL_REPORT_GENERATOR_PVT dependencies on OKL_REPORT_STREAM_PARAMS

Line 3179: FROM okl_report_stream_params rsp

3175: -- Stream Type should be setup as the Balancing Stream in Report Definition
3176: AND stm.sty_id IN
3177: (
3178: SELECT sty_id
3179: FROM okl_report_stream_params rsp
3180: WHERE rsp.report_id = p_report_id
3181: )
3182: AND stm.say_code <>'WORKING'
3183: -- Only Active Streams are used by down stream processes like Billing/Accrual

Line 6004: FROM okl_report_stream_params

6000: --Cursor to see if there are any stream types defined for a report
6001: CURSOR C_CHECK_STREAMS_DEFINED
6002: IS
6003: SELECT STY_ID
6004: FROM okl_report_stream_params
6005: WHERE report_id = p_report_id;
6006:
6007: --Cursor to fetch all accruable streams for a product
6008: CURSOR C_ALL_ACCRUABLE_STREAMS (p_pdt_id NUMBER)

Line 6028: FROM okl_report_stream_params

6024: AND trx.id = param.try_id
6025: AND trx.AEP_CODE = 'ACCRUAL'
6026: MINUS
6027: SELECT STY_ID
6028: FROM okl_report_stream_params
6029: WHERE report_id = p_report_id;
6030:
6031: --Cursor to fetch all products
6032: CURSOR C_GET_PRODUCTS

Line 6093: FROM okl_report_stream_params rsp

6089: AND psyy.accrual_yn = 'Y'
6090: and psyy.pdt_id = KH.PDT_ID
6091: UNION
6092: SELECT sty_id
6093: FROM okl_report_stream_params rsp
6094: WHERE rsp.report_id = p_report_id
6095: )
6096: and KH.ID = p_khr_id
6097: AND STM.ID IN ( SELECT MAX(ID)

Line 6181: FROM okl_report_stream_params rsp

6177: AND psyy.accrual_yn = 'Y'
6178: and psyy.pdt_id = KH.PDT_ID
6179: UNION
6180: SELECT sty_id
6181: FROM okl_report_stream_params rsp
6182: WHERE rsp.report_id = p_report_id
6183: )
6184: and KH.ID = p_khr_id
6185: AND STM.ID IN ( SELECT MAX(ID)