eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_GSP_DEFAULT dependencies on PQH_GSP_HR_TO_STAGE

Line 195: l_oipl_id := pqh_gsp_hr_to_stage.get_oipl_for_step

191: l_pl_id number;
192: begin
193: hr_utility.set_location('inside get elect chc',10);
194: if p_step_id is not null then
195: l_oipl_id := pqh_gsp_hr_to_stage.get_oipl_for_step
196: (p_step_id => p_step_id,
197: p_effective_date => p_effective_date);
198: hr_utility.set_location('oipl id is '||l_oipl_id,20);
199: end if;

Line 201: l_pl_id := pqh_gsp_hr_to_stage.get_plan_for_grade

197: p_effective_date => p_effective_date);
198: hr_utility.set_location('oipl id is '||l_oipl_id,20);
199: end if;
200: if p_grade_id is not null then
201: l_pl_id := pqh_gsp_hr_to_stage.get_plan_for_grade
202: (p_grade_id => p_grade_id,
203: p_effective_date => p_effective_date);
204: hr_utility.set_location('pl id is '||l_pl_id,30);
205: end if;

Line 387: l_pl_id := pqh_gsp_hr_to_stage.get_plan_for_grade

383: l_ordr_num number;
384: l_pl_id number;
385: begin
386: -- grade should be mapped to a plan which should be linked to a pgm as plip
387: l_pl_id := pqh_gsp_hr_to_stage.get_plan_for_grade
388: (p_grade_id => p_grade_id,
389: p_effective_date => p_effective_date);
390: if l_pl_id is not null then
391: hr_utility.set_location('pl id is '||l_pl_id,10);

Line 542: l_point_id := pqh_gsp_hr_to_stage.get_point_for_step

538: l_option_id number;
539: l_step_rate number;
540: begin
541: hr_utility.set_location('inside get_sal_for_step',10);
542: l_point_id := pqh_gsp_hr_to_stage.get_point_for_step
543: (p_step_id => p_step_id,
544: p_effective_date => p_effective_date);
545: hr_utility.set_location('point is '||l_point_id,20);
546: if l_point_id is not null then

Line 547: l_option_id := pqh_gsp_hr_to_stage.get_opt_for_point

543: (p_step_id => p_step_id,
544: p_effective_date => p_effective_date);
545: hr_utility.set_location('point is '||l_point_id,20);
546: if l_point_id is not null then
547: l_option_id := pqh_gsp_hr_to_stage.get_opt_for_point
548: (p_point_id => l_point_id,
549: p_effective_date => p_effective_date);
550: hr_utility.set_location('opt is '||l_option_id,30);
551: if l_option_id is not null then

Line 553: pqh_gsp_hr_to_stage.get_point_rate_values

549: p_effective_date => p_effective_date);
550: hr_utility.set_location('opt is '||l_option_id,30);
551: if l_option_id is not null then
552: hr_utility.set_location('going for point rate '||l_option_id,35);
553: pqh_gsp_hr_to_stage.get_point_rate_values
554: (p_effective_date => p_effective_date,
555: p_opt_id => l_option_id,
556: p_point_id => l_point_id,
557: p_point_value => l_step_rate);

Line 574: l_step_id := pqh_gsp_hr_to_stage.get_step_for_oipl(p_oipl_id => p_oipl_id,

570: l_next_step_id number;
571: l_next_oipl_id number;
572: begin
573: hr_utility.set_location('getting next oipl'||p_oipl_id,10);
574: l_step_id := pqh_gsp_hr_to_stage.get_step_for_oipl(p_oipl_id => p_oipl_id,
575: p_effective_date => p_effective_date);
576: hr_utility.set_location('step is'||l_step_id,20);
577: l_next_step_id := get_next_step(p_step_id => l_step_id,
578: p_effective_date => p_effective_date);

Line 581: l_next_oipl_id := pqh_gsp_hr_to_stage.get_oipl_for_step(p_step_id => l_next_step_id,

577: l_next_step_id := get_next_step(p_step_id => l_step_id,
578: p_effective_date => p_effective_date);
579: hr_utility.set_location('next step is'||l_next_step_id,30);
580: if nvl(l_next_step_id,0) > 0 then
581: l_next_oipl_id := pqh_gsp_hr_to_stage.get_oipl_for_step(p_step_id => l_next_step_id,
582: p_effective_date => p_effective_date);
583: else
584: l_next_oipl_id := l_next_step_id;
585: end if;

Line 667: l_pl_id := pqh_gsp_hr_to_stage.get_plan_for_grade

663: l_next_pl_id number;
664: l_next_grade_id number;
665: begin
666: hr_utility.set_location('getting next grade'||p_grade_id,10);
667: l_pl_id := pqh_gsp_hr_to_stage.get_plan_for_grade
668: (p_grade_id => p_grade_id,
669: p_effective_date => p_effective_date);
670: hr_utility.set_location('plan is'||l_pl_id,20);
671: if l_pl_id is null then

Line 680: l_next_grade_id := pqh_gsp_hr_to_stage.get_grade_for_plan

676: p_gl_id => p_gl_id,
677: p_effective_date => p_effective_date);
678: hr_utility.set_location('next plan is'||l_next_pl_id,30);
679: if nvl(l_next_pl_id,0) > 0 then
680: l_next_grade_id := pqh_gsp_hr_to_stage.get_grade_for_plan
681: (p_plan_id => l_next_pl_id,
682: p_effective_date => p_effective_date);
683: else
684: l_next_grade_id := l_next_pl_id;

Line 808: l_plan_id := pqh_gsp_hr_to_stage.get_plan_for_grade

804: close csr_asg_rec;
805: hr_utility.set_location('Assignment is valid'||l_assignment_id,11);
806: if l_grade_id is not null then
807: hr_utility.set_location('grade is'||l_grade_id,20);
808: l_plan_id := pqh_gsp_hr_to_stage.get_plan_for_grade
809: (p_grade_id => l_grade_id,
810: p_effective_date => p_effective_date);
811: hr_utility.set_location('plan is'||l_plan_id,30);
812: if l_plan_id is null then

Line 867: pqh_gsp_hr_to_stage.get_grd_scale_details

863: p_effective_date => p_effective_date,
864: p_emp_step_id => l_step_id,
865: p_num_incr => l_num_incr);
866: hr_utility.set_location('step id is '||l_step_id,55);
867: pqh_gsp_hr_to_stage.get_grd_scale_details
868: (p_grade_id => l_grade_id,
869: p_effective_date => p_effective_date,
870: p_scale_id => l_scale_id,
871: p_ceiling_step_id => l_ceiling_step_id,

Line 1205: Select pqh_gsp_hr_to_stage.get_step_for_oipl(Elctbl.oipl_id, p_effective_date) Step_Id

1201: l_min_incr_step_id number;
1202: l_next_sal number;
1203:
1204: Cursor Csr_Step is
1205: Select pqh_gsp_hr_to_stage.get_step_for_oipl(Elctbl.oipl_id, p_effective_date) Step_Id
1206: from Per_all_Assignments_F Asgt,
1207: Ben_Per_In_Ler Pler,
1208: Ben_Ler_F Ler,
1209: Ben_Elig_Per_Elctbl_Chc ELctbl,

Line 1223: and Elctbl.Pl_Id = pqh_gsp_hr_to_stage.get_plan_for_grade

1219: and P_Effective_Date
1220: Between ler.Effective_Start_Date
1221: and Ler.Effective_End_Date
1222: and Elctbl.Per_In_Ler_id = Pler.Per_In_ler_id
1223: and Elctbl.Pl_Id = pqh_gsp_hr_to_stage.get_plan_for_grade
1224: (p_grade_id, p_effective_date)
1225: and Elctbl.Oipl_id is NOT NULL
1226: and Rt.ELig_Per_Elctbl_Chc_Id = Elctbl.Elig_Per_Elctbl_Chc_id
1227: and Nvl(rt.ann_Val,0) > P_Cur_Sal