APPS.BEN_EXT_CHLG dependencies on PER_GRADES

Line 3133: from per_grades g

3129:
3130: cursor c_grade_name
3131: (p_grade_id number ,p_effective_date date) is
3132: select g.name
3133: from per_grades g
3134: where g.grade_id = p_grade_id
3135: and g.date_from <= p_effective_date
3136: and ((g.date_to is null) or (g.date_to >= p_effective_date )) ;
3137: --

Line 3147: l_old_grade_name per_grades.name%type;

3143: l_old_assignment_status per_assignment_status_types.user_status%type; -- UTF Change Bug 2254683
3144: l_new_assignment_status per_assignment_status_types.user_status%type; -- UTF Change Bug 2254683
3145: l_old_payroll_name pay_all_payrolls_f.payroll_name%type; --UTF Change Bug 2254683
3146: l_new_payroll_name pay_all_payrolls_f.payroll_name%type; --UTF Change Bug 2254683
3147: l_old_grade_name per_grades.name%type;
3148: l_new_grade_name per_grades.name%type;
3149: --
3150: l_proc varchar2(80) := 'ben_ext_chlg.log_asg_chg';
3151: --

Line 3148: l_new_grade_name per_grades.name%type;

3144: l_new_assignment_status per_assignment_status_types.user_status%type; -- UTF Change Bug 2254683
3145: l_old_payroll_name pay_all_payrolls_f.payroll_name%type; --UTF Change Bug 2254683
3146: l_new_payroll_name pay_all_payrolls_f.payroll_name%type; --UTF Change Bug 2254683
3147: l_old_grade_name per_grades.name%type;
3148: l_new_grade_name per_grades.name%type;
3149: --
3150: l_proc varchar2(80) := 'ben_ext_chlg.log_asg_chg';
3151: --
3152: begin