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.HRSPINE dependencies on PAY_GRADE_RULES_F

Line 131: --pay_grade_rules_f pgr2

127: per_spinal_point_placements_f spp,
128: per_spinal_points psp1,
129: per_spinal_point_steps_f sps1,
130: per_spinal_point_steps_f sps2
131: --pay_grade_rules_f pgr2
132: where spp1.step_id <> p_step_id -- 343
133: and spp1.effective_end_date = p_effective_start_date -1
134: and spp.effective_start_date = p_effective_start_date
135: and spp1.placement_id = p_placement_id

Line 179: pay_grade_rules_f pgr2,

175: from per_spinal_point_placements_f spp1,
176: per_spinal_point_placements_f spp,
177: per_spinal_points psp1,
178: per_spinal_point_steps_f sps1,
179: pay_grade_rules_f pgr2,
180: per_spinal_point_steps_f sps2
181: where p_step_id <> spp1.step_id
182: and spp1.effective_end_date = p_effective_start_date -1
183: and spp.effective_start_date = p_effective_start_date

Line 193: from pay_grade_rules_f pgr4

189: and spp.placement_id = spp1.placement_id
190: and sps1.spinal_point_id = psp1.spinal_point_id
191: and pgr2.grade_or_spinal_point_id = sps1.spinal_point_id
192: and pgr2.rate_id = (select min(rate_id)
193: from pay_grade_rules_f pgr4
194: where pgr4.grade_or_spinal_point_id = pgr2.grade_or_spinal_point_id
195: and (to_number(p_grade_rate) = pgr4.rate_id
196: or to_number(p_grade_rate) is null));
197: