APPS.OKL_REPORT_GENERATOR_PVT dependencies on OKL_REPORT_PARAMETERS

Line 292: FROM okl_report_parameters params

288: -----------------------------------------------------------------
289: CURSOR is_pdt_or_bc_present_csr( p_report_id NUMBER )
290: IS
291: SELECT DISTINCT 'Y' flag
292: FROM okl_report_parameters params
293: WHERE params.report_id = p_report_id
294: AND params.parameter_type_code IN
295: ( 'BOOK_CLASSIFICATION', 'PRODUCT' );
296:

Line 322: FROM okl_report_parameters params

318: AND gts.deal_type
319: IN
320: (
321: SELECT params.param_char_value1
322: FROM okl_report_parameters params
323: WHERE params.report_id = p_report_id
324: AND params.parameter_type_code = 'BOOK_CLASSIFICATION'
325: )
326: UNION

Line 330: FROM okl_report_parameters params

326: UNION
327: -- Append list of products from the report too
328: SELECT pdt.NAME product_name
329: ,pdt.id product_id
330: FROM okl_report_parameters params
331: ,okl_products pdt
332: WHERE params.report_id = p_report_id
333: AND params.parameter_type_code = 'PRODUCT'
334: AND params.param_num_value1 = pdt.id;

Line 7343: FROM okl_report_parameters oup

7339: -- Cursor to fetch teh Operating Unit
7340: CURSOR get_param_num_value( p_report_id NUMBER , p_parameter_type_code VARCHAR2)
7341: IS
7342: SELECT param_num_value1
7343: FROM okl_report_parameters oup
7344: WHERE oup.report_id = p_report_id
7345: AND oup.parameter_type_code = p_parameter_type_code ;
7346:
7347: -- Cursor to fetch GL Period From Date