DBA Data[Home] [Help]

APPS.BEN_PLAN_DESIGN_TXNS_API dependencies on PER_COMPETENCES_VL

Line 1326: from per_competences_vl

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;