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 PER_SPINAL_POINT_STEPS_F

Line 131: per_spinal_point_steps_f sps1,

127: select substr(psp1.spinal_point,1,20)
128: from per_spinal_point_placements_f spp1,
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

Line 132: per_spinal_point_steps_f sps2

128: from per_spinal_point_placements_f spp1,
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

Line 180: per_spinal_point_steps_f sps1,

176: select pgr2.value
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

Line 182: per_spinal_point_steps_f sps2

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
186: and spp1.placement_id = p_placement_id

Line 258: per_spinal_point_steps_f sps

254:
255: Cursor csr_increment2 is
256: select spp.placement_id
257: from per_spinal_point_placements_f spp,
258: per_spinal_point_steps_f sps
259: where spp.step_id = p_step_id
260: and spp.placement_id = p_placement_id
261: and spp.effective_end_date = p_effective_start_date -1
262: and sps.grade_spine_id = p_grade_spine_id

Line 282: per_spinal_point_steps_f sps,

278:
279: Cursor csr_increment4 is
280: select spp.placement_id
281: from per_spinal_point_placements_f spp,
282: per_spinal_point_steps_f sps,
283: per_spinal_points psp
284: where spp.placement_id = p_placement_id
285: and spp.effective_start_date = p_effective_start_date
286: and spp.step_id = p_step_id

Line 305: per_spinal_point_steps_f sps

301:
302: Cursor csr_all_placements is
303: select distinct spp.placement_id
304: from per_spinal_point_placements_f spp,
305: per_spinal_point_steps_f sps
306: where spp.placement_id = p_placement_id
307: and spp.effective_start_date = p_effective_start_date
308: and spp.step_id = sps.step_id
309: and spp.step_id = p_step_id

Line 610: from per_spinal_point_steps_f

606: cursor csr_next_sequence(p_sequence number,
607: p_grade_spine_id number,
608: p_effective_date date) is
609: select sequence,spinal_point_id
610: from per_spinal_point_steps_f
611: where sequence > p_sequence
612: and grade_spine_id = p_grade_spine_id
613: and p_effective_date between effective_start_date
614: and effective_end_date

Line 681: from per_spinal_point_steps_f

677: hr_utility.set_location('l_next_sequence_number '
678: ||l_next_sequence_number,1313);
679: select step_id
680: into l_new_step_id
681: from per_spinal_point_steps_f
682: where sequence = l_next_sequence_number
683: and grade_spine_id = p_grade_spine_id
684: and spinal_point_id = l_next_spinal_point;
685: EXCEPTION

Line 889: from per_spinal_point_steps_f sps,

885: BEGIN
886: select nvl(sps.sequence,-99),nvl(sps.grade_spine_id,-99)
887: into l_future_sequence_id,
888: l_future_grade_spine_id
889: from per_spinal_point_steps_f sps,
890: per_spinal_point_placements_f spp
891: where spp.effective_start_date = p_end_date + 1
892: and spp.placement_id = p_placement_id
893: and spp.step_id = sps.step_id;

Line 957: from per_spinal_point_steps_f sps

953: --
954: BEGIN
955: select sequence
956: into l_special_ceiling_sequence
957: from per_spinal_point_steps_f sps
958: where sps.grade_spine_id = p_grade_spine_id
959: and sps.step_id = l_special_ceiling_step_id
960: and p_effective_date between effective_start_date and effective_end_date;
961: EXCEPTION

Line 976: from per_spinal_point_steps_f sps

972: -- ------------------------------------------------------------------
973: BEGIN
974: select sps.step_id, sequence
975: into l_grade_max_step_id, l_grade_max_sequence
976: from per_spinal_point_steps_f sps
977: where sps.grade_spine_id = p_grade_spine_id
978: and sps.sequence = (select max(sequence)
979: from per_spinal_point_steps_f psp1
980: where grade_spine_id = p_grade_spine_id

Line 979: from per_spinal_point_steps_f psp1

975: into l_grade_max_step_id, l_grade_max_sequence
976: from per_spinal_point_steps_f sps
977: where sps.grade_spine_id = p_grade_spine_id
978: and sps.sequence = (select max(sequence)
979: from per_spinal_point_steps_f psp1
980: where grade_spine_id = p_grade_spine_id
981: and p_effective_date
982: between effective_start_date and effective_end_date);
983: EXCEPTION

Line 1048: per_spinal_point_steps_f sps1,

1044: l_max_spinal_point_id,
1045: l_max_special_spinal_point_id
1046: from per_spinal_points psp1,
1047: per_spinal_points psp2,
1048: per_spinal_point_steps_f sps1,
1049: per_spinal_point_steps_f sps2
1050: where psp1.spinal_point_id = sps1.spinal_point_id
1051: and psp2.spinal_point_id = sps2.spinal_point_id
1052: and sps1.step_id = l_max_ceiling_step_id

Line 1049: per_spinal_point_steps_f sps2

1045: l_max_special_spinal_point_id
1046: from per_spinal_points psp1,
1047: per_spinal_points psp2,
1048: per_spinal_point_steps_f sps1,
1049: per_spinal_point_steps_f sps2
1050: where psp1.spinal_point_id = sps1.spinal_point_id
1051: and psp2.spinal_point_id = sps2.spinal_point_id
1052: and sps1.step_id = l_max_ceiling_step_id
1053: and sps2.step_id = l_special_ceiling_step_id;

Line 1079: from per_spinal_point_steps_f sps

1075: hr_utility.set_location('p_sequence_number - '||p_sequence_number,333);
1076: BEGIN
1077: select count(sps.sequence)
1078: into l_max_count
1079: from per_spinal_point_steps_f sps
1080: where sps.sequence > p_sequence_number
1081: and sps.grade_spine_id = p_grade_spine_id
1082: and sps.sequence <= l_max_sequence_number
1083: and sps.sequence <= l_max_special_sequence_number

Line 1481: per_spinal_point_steps_f sps1,

1477: pgs.grade_spine_id
1478: FROM per_all_assignments_f asg,
1479: per_grade_spines_f pgs,
1480: per_spinal_points psp1,
1481: per_spinal_point_steps_f sps1,
1482: per_spinal_points psp,
1483: per_spinal_point_steps_f sps,
1484: per_spinal_point_placements_f spp,
1485: per_periods_of_service pps --12727056

Line 1483: per_spinal_point_steps_f sps,

1479: per_grade_spines_f pgs,
1480: per_spinal_points psp1,
1481: per_spinal_point_steps_f sps1,
1482: per_spinal_points psp,
1483: per_spinal_point_steps_f sps,
1484: per_spinal_point_placements_f spp,
1485: per_periods_of_service pps --12727056
1486: WHERE (p_parent_spine_id is null -- PARENT_SPINE_ID
1487: OR

Line 1588: per_spinal_point_steps_f sps1,

1584: FROM per_all_assignments_f asg,
1585: pay_people_groups ppg,
1586: per_grade_spines_f pgs,
1587: per_spinal_points psp1,
1588: per_spinal_point_steps_f sps1,
1589: per_spinal_points psp,
1590: per_spinal_point_steps_f sps,
1591: per_spinal_point_placements_f spp
1592: WHERE (p_parent_spine_id is null -- PARENT_SPINE_ID

Line 1590: per_spinal_point_steps_f sps,

1586: per_grade_spines_f pgs,
1587: per_spinal_points psp1,
1588: per_spinal_point_steps_f sps1,
1589: per_spinal_points psp,
1590: per_spinal_point_steps_f sps,
1591: per_spinal_point_placements_f spp
1592: WHERE (p_parent_spine_id is null -- PARENT_SPINE_ID
1593: OR
1594: (spp.parent_spine_id is not null