APPS.GHR_PRE_SHD SQL Statements

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

Line: 55

    select
      pa_remark_id,
	pa_request_id,
	remark_id,
	description,
      remark_code_information1,
      remark_code_information2,
      remark_code_information3,
      remark_code_information4,
      remark_code_information5,
	object_version_number
    from	ghr_pa_remarks
    where	pa_remark_id = p_pa_remark_id;

Line: 135

    select 	pa_remark_id,
	pa_request_id,
	remark_id,
	description,
      remark_code_information1,
      remark_code_information2,
      remark_code_information3,
      remark_code_information4,
      remark_code_information5,
	object_version_number
    from	ghr_pa_remarks
    where	pa_remark_id = p_pa_remark_id
    for	update nowait;