291: CURSOR csr_grade(c_grade_id IN Number
292: ,c_business_group_id IN Number
293: ,c_effective_date IN Date) IS
294: SELECT gtl.NAME
295: FROM per_grades pgr
296: ,per_grades_tl gtl
297: WHERE pgr.grade_id = c_grade_id
298: AND gtl.grade_id = pgr.grade_id
299: AND gtl.LANGUAGE = Userenv('LANG')
292: ,c_business_group_id IN Number
293: ,c_effective_date IN Date) IS
294: SELECT gtl.NAME
295: FROM per_grades pgr
296: ,per_grades_tl gtl
297: WHERE pgr.grade_id = c_grade_id
298: AND gtl.grade_id = pgr.grade_id
299: AND gtl.LANGUAGE = Userenv('LANG')
300: AND pgr.business_group_id = c_business_group_id
2741: l_location_code hr_locations_all.location_code%TYPE;
2742: l_payroll_name pay_payrolls_f.payroll_name%TYPE;
2743: l_job_name per_jobs.NAME%TYPE;
2744: l_position_name per_positions.NAME%TYPE;
2745: l_grade_name per_grades.NAME%TYPE;
2746: l_user_person_type per_person_types.user_person_type%TYPE;
2747: l_user_sequence Number := 1;
2748: l_link_value Number;
2749:
3933: l_location_code hr_locations_all.location_code%TYPE;
3934: l_payroll_name pay_payrolls_f.payroll_name%TYPE;
3935: l_job_name per_jobs.NAME%TYPE;
3936: l_position_name per_positions.NAME%TYPE;
3937: l_grade_name per_grades.NAME%TYPE;
3938:
3939: l_pradd_ovlapval_override Boolean;
3940:
3941: BEGIN