APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on PER_GRADES

Line 6193: from per_grades_vl gra

6189: l_out_grr_result_id number(15);
6190: --
6191: cursor c_get_mapping_name5(p_id in number,p_date in date) is
6192: select gra.name dsp_name
6193: from per_grades_vl gra
6194: where business_group_id = p_business_group_id
6195: and gra.grade_id = p_id
6196: and p_date between date_from and nvl(date_to, p_date) ;
6197: --

Line 6201: from per_grades

6197: --
6198:
6199: cursor c_grade_start_date(c_grade_id number) is
6200: select date_from
6201: from per_grades
6202: where grade_id = c_grade_id;
6203:
6204: l_grade_start_date per_grades.date_from%type;
6205: ---------------------------------------------------------------

Line 6204: l_grade_start_date per_grades.date_from%type;

6200: select date_from
6201: from per_grades
6202: where grade_id = c_grade_id;
6203:
6204: l_grade_start_date per_grades.date_from%type;
6205: ---------------------------------------------------------------
6206: -- END OF BEN_GRADE_RT_F ----------------------
6207: ---------------------------------------------------------------
6208: ---------------------------------------------------------------