[Home] [Help]
313: then
314: select
315: name into l_name
316: from
317: per_competences_vl
318: where
319: (business_group_id is null or business_group_id = l_business_group_id)
320: and competence_id = l_crit.information174
321: and (date_from is null or date_from <= p_effective_date)