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.HR_ASSIGNMENT_INTERNAL dependencies on PER_SPINAL_POINT_STEPS_F

Line 2880: per_spinal_point_steps_f sps,

2876: spp.placement_id,
2877: spp.effective_start_date,
2878: spp.effective_end_date
2879: from per_grade_spines_f pgs,
2880: per_spinal_point_steps_f sps,
2881: per_spinal_point_placements_f spp
2882: where sps.grade_spine_id = pgs.grade_spine_id
2883: and spp.step_id = sps.step_id
2884: and pgs.parent_spine_id = spp.parent_spine_id

Line 2893: per_spinal_point_steps_f sps,

2889: -- validation_start_date and effective_end_date is > validation_end_date
2890: cursor csr_asg_spp_error(l_asg_eff_start_date date, l_asg_eff_end_date date) is
2891: select pgs.grade_id
2892: from per_grade_spines_f pgs,
2893: per_spinal_point_steps_f sps,
2894: per_spinal_point_placements_f spp
2895: where sps.grade_spine_id = pgs.grade_spine_id
2896: and spp.step_id = sps.step_id
2897: and pgs.parent_spine_id = spp.parent_spine_id

Line 3063: per_spinal_point_steps_f sps,

3059: -- Cursor to get the Grade of future SPP
3060: cursor csr_spp_grade is
3061: select pgs.grade_id
3062: from per_grade_spines_f pgs,
3063: per_spinal_point_steps_f sps,
3064: per_spinal_point_placements_f spp
3065: where sps.grade_spine_id = pgs.grade_spine_id
3066: and spp.step_id = sps.step_id
3067: and pgs.parent_spine_id = spp.parent_spine_id

Line 4145: l_min_step_id per_spinal_point_steps_f.step_id%Type;

4141: l_future_spp_exist boolean := false;
4142: l_pay_scale_defined boolean := false;
4143: l_placement_id per_spinal_point_placements_f.placement_id%Type;
4144: l_object_version_number per_spinal_point_placements_f.object_version_number%Type;
4145: l_min_step_id per_spinal_point_steps_f.step_id%Type;
4146: l_grade_spine_id per_grade_spines_f.grade_spine_id%Type;
4147: l_dummy_id per_spinal_point_placements_f.placement_id%Type;
4148: -- This warning variable will be used, whenever system internaly delete's
4149: -- any future dated SPP records or End Date an SPP record whcih is having

Line 4190: per_spinal_point_steps_f sps

4186: -- for the new grade
4187: cursor csr_new_grade_scale is
4188: select sps.step_id
4189: from per_grade_spines_f pgs,
4190: per_spinal_point_steps_f sps
4191: where sps.grade_spine_id = pgs.grade_spine_id
4192: and p_validation_start_date between sps.effective_start_date
4193: and sps.effective_end_date
4194: and pgs.grade_id = p_grade_id

Line 4199: from per_spinal_point_steps_f sps2

4195: and p_validation_start_date between pgs.effective_start_date
4196: and pgs.effective_end_date
4197: and sps.sequence in (
4198: select min(sps2.sequence)
4199: from per_spinal_point_steps_f sps2
4200: where sps2.grade_spine_id = pgs.grade_spine_id
4201: and p_validation_start_date between sps2.effective_start_date
4202: and sps2.effective_end_date);
4203: -- Cursor to check if the new Grade has been linked to a Pay Scale at any time

Line 6102: from per_spinal_point_steps_f

6098: where assignment_status_type_id = per_asg_shd.g_old_rec.assignment_status_type_id;
6099: --
6100: cursor csr_ass_step_sequence is
6101: select sequence
6102: from per_spinal_point_steps_f
6103: where step_id = per_asg_shd.g_old_rec.special_ceiling_step_id
6104: and p_effective_date between effective_start_date and effective_end_date;
6105: --
6106: cursor csr_ass_row_id is