eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PLAN_DESIGN_TXNS_API dependencies on PER_COMPETENCES

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;

Line 1530: per_competences pct

1526: ,p_competence_id number) is
1527: select rtl.name,
1528: rtl.rating_level_id id
1529: from per_rating_levels_vl rtl, /* MLS Changes*/
1530: per_competences pct
1531: where (rtl.competence_id = pct.competence_id
1532: or rtl.rating_scale_id = pct.rating_scale_id )
1533: and pct.competence_id = p_competence_id
1534: and nvl(rtl.business_group_id, p_target_business_group_id ) = p_target_business_group_id