APPS.PER_ZA_ASS_SHD SQL Statements

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

Line: 75

    select
  		assessment_id,
  		person_id,
  		level_id,
  		name_of_assessor,
  		institution,
  		credit,
  		date_of_assessment,
  		final_result,
  		assessment_number,
  		location_where_assessed,
  		field_of_learning,
		sub_field,
		assessment_start_date,
		assessment_end_date,
		competence_acquired,
		ETQA_name,
		certification_date,
		certificate_number,
		accredited_by,
		date_of_accreditation,
		certification_expiry_date
    from
    	per_za_assessments
    where
    	assessment_id = p_assessment_id
    for	update nowait;