APPS.OKL_FORMULAEVALUATE_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 23

	SELECT
		'1'
	FROM
		okl_formulae_v
	WHERE
		id = p_fma_id;

Line: 42

			based on the results update the boolean flag
			and return it to the calling API. **/
	OPEN fma_cur;

Line: 79

	SELECT
		dsfv.id,
		dsfv.name,
		dsfv.source,
		dsfv.fnctn_code
	FROM
		okl_formulae_v fmav,
		okl_data_src_fnctns_v dsfv,
		okl_operands_v opdv,
		okl_fmla_oprnds_v fodv
	WHERE
		fmav.id = p_fma_id
	AND	fmav.id = fodv.fma_id
	AND	fodv.opd_id = opdv.id
	AND	opdv.dsf_id = dsfv.id;

Line: 135

	SELECT
		cgrpv.pmr_id, pmrv.name
	FROM
		okl_formulae_v fmav,
		okl_context_groups_v cgrv,
		okl_cntx_grp_prmtrs_v cgrpv,
		okl_parameters_v pmrv
	WHERE
		fmav.id = p_fma_id
	AND	cgrv.id = fmav.cgr_id
	AND	fmav.cgr_id = cgrpv.cgr_id
	AND	pmrv.id = cgrpv.pmr_id;

Line: 198

	l_QueryString := 'select ' || p_function_string || ' from dual';

Line: 230

	SELECT
		fprv.pmr_id, fprv.sequence_number
	FROM
		okl_parameters_v pmrv,
		okl_data_src_fnctns_v dsfv,
		okl_fnctn_prmtrs_v fprv
	WHERE
		dsfv.id = p_function_rec.function_id
	AND	dsfv.id = fprv.dsf_id
	AND	fprv.pmr_id = pmrv.id
	ORDER BY
		fprv.sequence_number;