APPS.OKL_FORMULAVALIDATE_PVT SQL Statements

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

Line: 22

	SELECT
		pmrv.id
	FROM
		okl_fnctn_prmtrs_v fprv,
		okl_parameters_v pmrv
	WHERE
		fprv.dsf_id IN
		( SELECT
			dsfv.id
		FROM
			okl_formulae_v fmav,
			okl_operands_v opdv,
			okl_fmla_oprnds_v fodv,
			okl_data_src_fnctns_v dsfv
		WHERE
			fmav.id = p_fma_id
		AND	fmav.id = fodv.fma_id
		AND	fodv.opd_id = opdv.id
		AND opdv.opd_type = 'FCNT'
		AND	opdv.dsf_id = dsfv.id )
	AND	fprv.pmr_id = pmrv.id;

Line: 177

	SELECT opdv.fma_id
	FROM
		okl_formulae_v fmav,
		okl_fmla_oprnds_v fodv,
		okl_operands_v opdv
	WHERE
		fmav.id = p_l_fma_id
	AND	fodv.fma_id = fmav.id
	AND	opdv.id = fodv.opd_id
	AND	opdv.opd_type = 'FMLA';

Line: 243

			INFO: Delete PL/SQL table entries. **/
		l_newfmaopd_tbl.delete;