APPS.HR_COMP_PROFILE_SS dependencies on PER_ALL_ASSIGNMENTS_F

Line 3684: From per_competence_elements pce, per_all_assignments_f paaf,

3680: l_proc varchar2(200) := g_package || 'get_preferred_prof_range';
3681: Cursor csr_bg_profrange is
3682: Select rl1.step_value || decode(rl1.name, '', '', ' ' || rl1.name) minprof,
3683: rl2.step_value || decode(rl2.name, '', '', ' ' || rl2.name) maxprof
3684: From per_competence_elements pce, per_all_assignments_f paaf,
3685: per_rating_levels rl1, per_rating_levels rl2
3686: Where paaf.person_id = p_person_id
3687: And trunc(sysdate) between paaf.effective_start_date and paaf.effective_end_date
3688: And pce.enterprise_id = paaf.business_group_id

Line 3697: From per_competence_elements pce, per_all_assignments_f paaf,

3693: And high_proficiency_level_id = rl2.rating_level_id (+);
3694: Cursor csr_job_profrange is
3695: Select rl1.step_value || decode(rl1.name, '', '', ', ' || rl1.name) minprof,
3696: rl2.step_value || decode(rl2.name, '', '', ', ' || rl2.name) maxprof
3697: From per_competence_elements pce, per_all_assignments_f paaf,
3698: per_rating_levels rl1, per_rating_levels rl2
3699: Where paaf.person_id = p_person_id
3700: And trunc(sysdate) between paaf.effective_start_date and paaf.effective_end_date
3701: And pce.job_id = paaf.job_id

Line 3710: From per_competence_elements pce, per_all_assignments_f paaf,

3706: And high_proficiency_level_id = rl2.rating_level_id (+);
3707: Cursor csr_pos_profrange is
3708: Select rl1.step_value || decode(rl1.name, '', '', ', ' || rl1.name) minprof,
3709: rl2.step_value || decode(rl2.name, '', '', ', ' || rl2.name) maxprof
3710: From per_competence_elements pce, per_all_assignments_f paaf,
3711: per_rating_levels rl1, per_rating_levels rl2
3712: Where paaf.person_id = p_person_id
3713: And trunc(sysdate) between paaf.effective_start_date and paaf.effective_end_date
3714: And pce.position_id = paaf.position_id

Line 3723: From per_competence_elements pce, per_all_assignments_f paaf,

3719: And high_proficiency_level_id = rl2.rating_level_id (+);
3720: Cursor csr_org_profrange is
3721: Select rl1.step_value || decode(rl1.name, '', '', ', ' || rl1.name) minprof,
3722: rl2.step_value || decode(rl2.name, '', '', ', ' || rl2.name) maxprof
3723: From per_competence_elements pce, per_all_assignments_f paaf,
3724: per_rating_levels rl1, per_rating_levels rl2
3725: Where paaf.person_id = p_person_id
3726: And trunc(sysdate) between paaf.effective_start_date and paaf.effective_end_date
3727: And pce.organization_id = paaf.organization_id

Line 3806: From per_competence_elements pce, per_all_assignments_f paaf, per_competences pc

3802: | given person and competence. |
3803: +------------------------------------------------------------*/
3804: Cursor prof_rec is
3805: Select 'Y'
3806: From per_competence_elements pce, per_all_assignments_f paaf, per_competences pc
3807: Where paaf.person_id = p_person_id
3808: And trunc(sysdate) between paaf.effective_start_date and paaf.effective_end_date
3809: And pc.competence_id = p_competence_id
3810: And pce.competence_id = pc.competence_id