APPS.PER_CPN_BUS dependencies on PER_COMPETENCE_ELEMENTS

Line 238: from per_competence_elements cpe

234: -- competence end date.
235:
236: Cursor csr_check_dates_in_ele is
237: select 'Y'
238: from per_competence_elements cpe
239: where ( nvl(cpe.effective_date_from,hr_api.g_sot) <
240: nvl(p_date_from, nvl(cpe.effective_date_from,hr_api.g_sot))
241: or nvl(cpe.effective_date_from,hr_api.g_sot) >
242: nvl(p_date_to, nvl(cpe.effective_date_from,hr_api.g_sot))

Line 1018: per_competence_elements ce

1014: --
1015: cursor csr_rating_level_in_ele is
1016: select 'Y'
1017: from per_rating_levels rl,
1018: per_competence_elements ce
1019: where ((rl.rating_level_id = ce.proficiency_level_id) or
1020: (rl.rating_level_id = ce.high_proficiency_level_id))
1021: and rl.rating_scale_id = nvl(per_cpn_shd.g_old_rec.rating_scale_id,-9999)
1022: and ce.competence_id = p_competence_id;

Line 1107: -- Cursor to check if competence is used in per_competence_elements

1103: --
1104: l_exists varchar2(1);
1105: l_proc varchar2(72) := g_package||'chk_competence_delete';
1106: --
1107: -- Cursor to check if competence is used in per_competence_elements
1108: --
1109: cursor csr_chk_comp_exists_in_ele is
1110: select 'Y'
1111: from per_competence_elements

Line 1111: from per_competence_elements

1107: -- Cursor to check if competence is used in per_competence_elements
1108: --
1109: cursor csr_chk_comp_exists_in_ele is
1110: select 'Y'
1111: from per_competence_elements
1112: where competence_id = p_competence_id;
1113: --
1114: -- Cursor to check if competence is used in per_rating_levels
1115: --