APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on PER_COMPETENCES

Line 7192: from per_competences_vl

7188: l_out_cty_result_id number(15);
7189: --
7190: cursor c_get_mapping_name16(p_COMPETENCE_ID number,p_date date) is
7191: select name
7192: from per_competences_vl
7193: where COMPETENCE_ID = p_COMPETENCE_ID
7194: and p_date
7195: between Date_from and nvl(Date_to, p_date);
7196: --

Line 7206: from per_competences

7202: where nvl(rtl.business_group_id, p_business_group_id) = p_business_group_id and rtl.rating_level_id = p_rating_level_id;
7203: --
7204: cursor c_competence_start_date(c_competence_id number) is
7205: select date_from
7206: from per_competences
7207: where competence_id = c_competence_id;
7208:
7209: l_competence_start_date per_competences.date_from%type;
7210: ---------------------------------------------------------------

Line 7209: l_competence_start_date per_competences.date_from%type;

7205: select date_from
7206: from per_competences
7207: where competence_id = c_competence_id;
7208:
7209: l_competence_start_date per_competences.date_from%type;
7210: ---------------------------------------------------------------
7211: -- END OF BEN_COMPTNCY_RT_F ----------------------
7212: ---------------------------------------------------------------
7213: ---------------------------------------------------------------