APPS.GHR_NRE_SHD SQL Statements

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

Line: 60

    select
		noac_remark_id,
	nature_of_action_id,
	remark_id,
	required_flag,
	enabled_flag,
	date_from,
	date_to,
	object_version_number
    from	ghr_noac_remarks
    where	noac_remark_id = p_noac_remark_id;

Line: 138

    select 	noac_remark_id,
	nature_of_action_id,
	remark_id,
	required_flag,
	enabled_flag,
	date_from,
	date_to,
	object_version_number
    from	ghr_noac_remarks
    where	noac_remark_id = p_noac_remark_id
    for	update nowait;