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 133: --pay_grade_rules_f pgr2

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

Line 181: pay_grade_rules_f pgr2,

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

Line 195: from pay_grade_rules_f pgr4

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