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.PER_CEL_BUS dependencies on PER_COMPETENCES

Line 1200: from per_competences

1196: -- Cursor to check that competence_id exists
1197: --
1198: cursor csr_valid_competence_id is
1199: select business_group_id, date_from, date_to
1200: from per_competences
1201: where p_competence_id = competence_id;
1202: -- and nvl(p_effective_date_from,hr_api.g_eot) >= date_from
1203: -- and nvl(p_effective_date_to,hr_api.g_eot)<=
1204: -- nvl(date_to,hr_api.g_eot);

Line 1215: from per_competences

1211: -- AND ASSESSMENT_COMPETENCE type.
1212: --
1213: cursor csr_usage_competence_id is
1214: select business_group_id
1215: from per_competences
1216: where p_competence_id = competence_id;
1217:
1218: --
1219: -- cursor to check that the organization_id is valid

Line 2253: per_competences comp

2249:
2250: select ral.step_value
2251: from per_rating_levels ral,
2252: per_rating_scales ras,
2253: per_competences comp
2254: where p_competence_id = comp.competence_id
2255: and ras.rating_scale_id = comp.rating_scale_id
2256: and ral.rating_scale_id = ras.rating_scale_id
2257: and p_prof_id = ral.rating_level_id;