APPS.PQH_GSP_HR_TO_STAGE dependencies on PER_GRADES

Line 2174: and mapping_table_name ='PER_GRADES';

2170: into l_grade_id
2171: from ben_pl_f
2172: where pl_id = p_plan_id
2173: and p_effective_date between effective_start_date and effective_end_date
2174: and mapping_table_name ='PER_GRADES';
2175: hr_utility.set_location('grade id is'||l_grade_id,10);
2176: return l_grade_id;
2177: exception
2178: when no_data_found then

Line 2194: and mapping_table_name ='PER_GRADES';

2190: into l_pl_id
2191: from ben_pl_f
2192: where mapping_table_pk_id = p_grade_id
2193: and p_effective_date between effective_start_date and effective_end_date
2194: and mapping_table_name ='PER_GRADES';
2195: hr_utility.set_location('plan id is'||l_pl_id,10);
2196: return l_pl_id;
2197: exception
2198: when no_data_found then

Line 2591: from per_grades

2587: select date_from, date_to, short_name, name,
2588: grade_definition_id, object_version_number
2589: into p_date_from,p_date_to,p_short_name,p_grade_name,
2590: p_grade_definition_id,p_grd_ovn
2591: from per_grades
2592: where grade_id = p_grade_id;
2593: hr_utility.set_location('grade name'||p_grade_name,20);
2594: exception
2595: when no_data_found then

Line 3559: l_short_name per_grades.short_name%type;

3555: --
3556: l_proc varchar2(61) :='Grade_to_stage';
3557: l_date_from date;
3558: l_date_to date;
3559: l_short_name per_grades.short_name%type;
3560: l_grade_name per_grades.name%type;
3561: l_grade_definition_id number;
3562: l_grd_ovn number;
3563: begin

Line 3560: l_grade_name per_grades.name%type;

3556: l_proc varchar2(61) :='Grade_to_stage';
3557: l_date_from date;
3558: l_date_to date;
3559: l_short_name per_grades.short_name%type;
3560: l_grade_name per_grades.name%type;
3561: l_grade_definition_id number;
3562: l_grd_ovn number;
3563: begin
3564: hr_utility.set_location('inside'||l_proc,10);

Line 3651: l_short_name per_grades.short_name%type;

3647: --
3648: l_proc varchar2(61) :='grade_to_plip_stage';
3649: l_date_from date;
3650: l_date_to date;
3651: l_short_name per_grades.short_name%type;
3652: l_grade_name per_grades.name%type;
3653: l_grade_definition_id number;
3654: l_grd_ovn number;
3655:

Line 3652: l_grade_name per_grades.name%type;

3648: l_proc varchar2(61) :='grade_to_plip_stage';
3649: l_date_from date;
3650: l_date_to date;
3651: l_short_name per_grades.short_name%type;
3652: l_grade_name per_grades.name%type;
3653: l_grade_definition_id number;
3654: l_grd_ovn number;
3655:
3656: l_scale_id number;

Line 5370: l_short_name per_grades.short_name%type;

5366: l_pln_tr_id number;
5367: l_pln_tr_name varchar2(80);
5368: l_date_from date;
5369: l_date_to date;
5370: l_short_name per_grades.short_name%type;
5371: l_grade_name per_grades.name%type;
5372: l_grade_definition_id number;
5373: l_grd_ovn number;
5374: begin

Line 5371: l_grade_name per_grades.name%type;

5367: l_pln_tr_name varchar2(80);
5368: l_date_from date;
5369: l_date_to date;
5370: l_short_name per_grades.short_name%type;
5371: l_grade_name per_grades.name%type;
5372: l_grade_definition_id number;
5373: l_grd_ovn number;
5374: begin
5375: get_table_route_details(p_table_alias => 'PLN',

Line 5407: ,p_information141 => 'PER_GRADES'

5403: ,p_information307 => l_date_from
5404: ,p_information308 => l_date_to
5405: ,p_information222 => l_grd_ovn
5406: ,p_information223 => p_grade_id
5407: ,p_information141 => 'PER_GRADES'
5408: ,p_information294 => p_grade_id
5409: ,p_information102 => l_short_name
5410: ,p_copy_entity_result_id => p_pl_cer_id
5411: ,p_object_version_number => p_pl_cer_ovn);