APPS.PER_ZA_AO_ASS_SHD SQL Statements

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

Line: 75

    select
	    area_of_assessment_id,
  		assessment_id,
		area_of_assessment,
		assessment_result,
		assessment_criteria
    from
    	per_za_areas_of_assessment
    where
    	area_of_assessment_id = p_area_of_assessment_id
    for	update nowait;

Line: 167

    select
	    PER_ZA_AREAS_OF_ASSESSMENT_S.nextval
	into
	    p_area_of_assessment_id
	from
	    dual;