APPS.PROJECT_MFG SQL Statements

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

Line: 17

		select
		br.expenditure_type
 		into l_expend_type
		from
		BOM_RESOURCES br,
		CST_ITEM_COST_DETAILS cicd
		where
		cicd.inventory_item_id		=	I_ITEM_ID	and
		cicd.organization_id		=	I_ORG_ID	and
		cicd.cost_type_id		=  nvl(I_RATES_COST_TYPE_ID,-1)	and
		cicd.resource_id		=	br.resource_id	and
		cicd.cost_element_id		=	1		and
		br.organization_id		=	I_ORG_ID	and
		rownum 				=	1
		order by cicd.resource_id;

Line: 45

	select nvl(br.expenditure_type,'No Val')
	into
	l_expend_type
	from
	BOM_RESOURCES br,
	MTL_PARAMETERS mp
	where
	mp.organization_id	=	I_ORG_ID	and
	mp.default_material_cost_id	=	br.resource_id	and
	br.organization_id		=	I_ORG_ID;