APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on PER_COMPETENCES

Line 3520: from per_competences_vl

3516: l_out_ecy_result_id number(15);
3517: --
3518: cursor c_get_mapping_name16(p_COMPETENCE_ID number,p_date date) is
3519: select name
3520: from per_competences_vl
3521: where competence_id = p_competence_id
3522: and p_date
3523: between Date_from and nvl(Date_to, p_date);
3524: --

Line 3535: from per_competences

3531: and rtl.rating_level_id = p_rating_level_id;
3532: --
3533: cursor c_competence_start_date(c_competence_id number) is
3534: select date_from
3535: from per_competences
3536: where competence_id = c_competence_id;
3537:
3538: l_competence_start_date per_competences.date_from%type;
3539: ---------------------------------------------------------------

Line 3538: l_competence_start_date per_competences.date_from%type;

3534: select date_from
3535: from per_competences
3536: where competence_id = c_competence_id;
3537:
3538: l_competence_start_date per_competences.date_from%type;
3539: ---------------------------------------------------------------
3540: -- END OF BEN_ELIG_COMPTNCY_PRTE_F ----------------------
3541: ---------------------------------------------------------------
3542: