APPS.PQH_CEP_SHD SQL Statements

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

Line: 64

    select
		copy_entity_pref_id,
	table_route_id,
	copy_entity_txn_id,
	select_flag,
	object_version_number
    from	pqh_copy_entity_prefs
    where	copy_entity_pref_id = p_copy_entity_pref_id;

Line: 139

    select 	copy_entity_pref_id,
	table_route_id,
	copy_entity_txn_id,
	select_flag,
	object_version_number
    from	pqh_copy_entity_prefs
    where	copy_entity_pref_id = p_copy_entity_pref_id
    for	update nowait;

Line: 199

	p_select_flag                   in varchar2,
	p_object_version_number         in number
	)
	Return g_rec_type is
--
  l_rec	  g_rec_type;

Line: 216

  l_rec.select_flag                      := p_select_flag;