[Home] [Help]
1322: cursor c_CompetenceIdNameLovVO(p_source_name1 varchar2,
1323: cv_effective_date date) is
1324: select name name
1325: ,competence_id id
1326: from per_competences_vl
1327: where trunc(cv_effective_date)
1328: between Date_from and nvl(Date_to, trunc(cv_effective_date) )
1329: and nvl(business_group_id , p_target_business_group_id) = p_target_business_group_id
1330: and name = p_source_name1;