APPS.PQH_GSP_HR_TO_STAGE dependencies on BEN_PL_F

Line 2171: from ben_pl_f

2167: l_grade_id number;
2168: begin
2169: select mapping_table_pk_id
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);

Line 2191: from ben_pl_f

2187: l_pl_id number;
2188: begin
2189: select pl_id
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);

Line 3578: -- These mappings have been taken from hrben_to_stage document ben_pl_f addition columns section.

3574: end if;
3575: if p_pl_cer_id is not null then
3576: -- update plan row with Grade data
3577: begin
3578: -- These mappings have been taken from hrben_to_stage document ben_pl_f addition columns section.
3579: update ben_copy_entity_results set
3580: information5 = nvl(l_grade_name,information5), -- plan name is overridden by Grade Name
3581: information102 = nvl(l_short_name,information102),
3582: information221 = nvl(l_grade_definition_id,information221),