APPS.GHR_NLA_SHD SQL Statements

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

Line: 55

    select
		noac_la_id,
	nature_of_action_id,
	lac_lookup_code,
	enabled_flag,
	date_from,
	date_to,
	object_version_number,
	valid_first_lac_flag,
	valid_second_lac_flag
    from	ghr_noac_las
    where	noac_la_id = p_noac_la_id;

Line: 134

    select 	noac_la_id,
	nature_of_action_id,
	lac_lookup_code,
	enabled_flag,
	date_from,
	date_to,
	object_version_number,
	valid_first_lac_flag,
	valid_second_lac_flag
    from	ghr_noac_las
    where	noac_la_id = p_noac_la_id
    for	update nowait;