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 129: per_spinal_point_steps_f sps1,

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

Line 130: per_spinal_point_steps_f sps2

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

Line 178: per_spinal_point_steps_f sps1,

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

Line 180: per_spinal_point_steps_f sps2

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

Line 256: per_spinal_point_steps_f sps

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

Line 280: per_spinal_point_steps_f sps,

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

Line 303: per_spinal_point_steps_f sps

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

Line 608: from per_spinal_point_steps_f

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

Line 679: from per_spinal_point_steps_f

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

Line 887: from per_spinal_point_steps_f sps,

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

Line 955: from per_spinal_point_steps_f sps

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

Line 974: from per_spinal_point_steps_f sps

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

Line 977: from per_spinal_point_steps_f psp1

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

Line 1046: per_spinal_point_steps_f sps1,

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

Line 1047: per_spinal_point_steps_f sps2

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

Line 1077: from per_spinal_point_steps_f sps

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

Line 1479: per_spinal_point_steps_f sps1,

1475: pgs.grade_spine_id
1476: FROM per_all_assignments_f asg,
1477: per_grade_spines_f pgs,
1478: per_spinal_points psp1,
1479: per_spinal_point_steps_f sps1,
1480: per_spinal_points psp,
1481: per_spinal_point_steps_f sps,
1482: per_spinal_point_placements_f spp
1483: WHERE (p_parent_spine_id is null -- PARENT_SPINE_ID

Line 1481: per_spinal_point_steps_f sps,

1477: per_grade_spines_f pgs,
1478: per_spinal_points psp1,
1479: per_spinal_point_steps_f sps1,
1480: per_spinal_points psp,
1481: per_spinal_point_steps_f sps,
1482: per_spinal_point_placements_f spp
1483: WHERE (p_parent_spine_id is null -- PARENT_SPINE_ID
1484: OR
1485: (spp.parent_spine_id is not null

Line 1581: per_spinal_point_steps_f sps1,

1577: FROM per_all_assignments_f asg,
1578: pay_people_groups ppg,
1579: per_grade_spines_f pgs,
1580: per_spinal_points psp1,
1581: per_spinal_point_steps_f sps1,
1582: per_spinal_points psp,
1583: per_spinal_point_steps_f sps,
1584: per_spinal_point_placements_f spp
1585: WHERE (p_parent_spine_id is null -- PARENT_SPINE_ID

Line 1583: per_spinal_point_steps_f sps,

1579: per_grade_spines_f pgs,
1580: per_spinal_points psp1,
1581: per_spinal_point_steps_f sps1,
1582: per_spinal_points psp,
1583: per_spinal_point_steps_f sps,
1584: per_spinal_point_placements_f spp
1585: WHERE (p_parent_spine_id is null -- PARENT_SPINE_ID
1586: OR
1587: (spp.parent_spine_id is not null