DBA Data[Home] [Help]

APPS.HR_MEE_VIEWS_GEN dependencies on PER_SPINAL_POINTS

Line 560: from pay_grade_rules_f pgr, per_spinal_points psp, per_spinal_point_steps_f psps

556: ) return varchar2 is
557:
558: cursor c_step_details is
559: select pgr.value , psp.spinal_point
560: from pay_grade_rules_f pgr, per_spinal_points psp, per_spinal_point_steps_f psps
561: where psps.step_id = p_step_id and psps.spinal_point_id=psp.spinal_point_id
562: and pgr.grade_or_spinal_point_id=psps.spinal_point_id and pgr.rate_type='SP'
563: and p_eff_date between pgr.effective_start_date and pgr.effective_end_date
564: and p_eff_date between psps.effective_start_date and psps.effective_end_date;