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 3013: per_spinal_point_steps_f sps,

3009: spp.placement_id,
3010: spp.effective_start_date,
3011: spp.effective_end_date
3012: from per_grade_spines_f pgs,
3013: per_spinal_point_steps_f sps,
3014: per_spinal_point_placements_f spp
3015: where sps.grade_spine_id = pgs.grade_spine_id
3016: and spp.step_id = sps.step_id
3017: and pgs.parent_spine_id = spp.parent_spine_id

Line 3026: per_spinal_point_steps_f sps,

3022: -- validation_start_date and effective_end_date is > validation_end_date
3023: cursor csr_asg_spp_error(l_asg_eff_start_date date, l_asg_eff_end_date date) is
3024: select pgs.grade_id
3025: from per_grade_spines_f pgs,
3026: per_spinal_point_steps_f sps,
3027: per_spinal_point_placements_f spp
3028: where sps.grade_spine_id = pgs.grade_spine_id
3029: and spp.step_id = sps.step_id
3030: and pgs.parent_spine_id = spp.parent_spine_id

Line 3196: per_spinal_point_steps_f sps,

3192: -- Cursor to get the Grade of future SPP
3193: cursor csr_spp_grade is
3194: select pgs.grade_id
3195: from per_grade_spines_f pgs,
3196: per_spinal_point_steps_f sps,
3197: per_spinal_point_placements_f spp
3198: where sps.grade_spine_id = pgs.grade_spine_id
3199: and spp.step_id = sps.step_id
3200: and pgs.parent_spine_id = spp.parent_spine_id

Line 4278: l_min_step_id per_spinal_point_steps_f.step_id%Type;

4274: l_future_spp_exist boolean := false;
4275: l_pay_scale_defined boolean := false;
4276: l_placement_id per_spinal_point_placements_f.placement_id%Type;
4277: l_object_version_number per_spinal_point_placements_f.object_version_number%Type;
4278: l_min_step_id per_spinal_point_steps_f.step_id%Type;
4279: l_grade_spine_id per_grade_spines_f.grade_spine_id%Type;
4280: l_dummy_id per_spinal_point_placements_f.placement_id%Type;
4281: -- This warning variable will be used, whenever system internaly delete's
4282: -- any future dated SPP records or End Date an SPP record whcih is having

Line 4323: per_spinal_point_steps_f sps

4319: -- for the new grade
4320: cursor csr_new_grade_scale is
4321: select sps.step_id
4322: from per_grade_spines_f pgs,
4323: per_spinal_point_steps_f sps
4324: where sps.grade_spine_id = pgs.grade_spine_id
4325: and p_validation_start_date between sps.effective_start_date
4326: and sps.effective_end_date
4327: and pgs.grade_id = p_grade_id

Line 4332: from per_spinal_point_steps_f sps2

4328: and p_validation_start_date between pgs.effective_start_date
4329: and pgs.effective_end_date
4330: and sps.sequence in (
4331: select min(sps2.sequence)
4332: from per_spinal_point_steps_f sps2
4333: where sps2.grade_spine_id = pgs.grade_spine_id
4334: and p_validation_start_date between sps2.effective_start_date
4335: and sps2.effective_end_date);
4336: -- Cursor to check if the new Grade has been linked to a Pay Scale at any time

Line 6316: from per_spinal_point_steps_f

6312: where assignment_status_type_id = per_asg_shd.g_old_rec.assignment_status_type_id;
6313: --
6314: cursor csr_ass_step_sequence is
6315: select sequence
6316: from per_spinal_point_steps_f
6317: where step_id = per_asg_shd.g_old_rec.special_ceiling_step_id
6318: and p_effective_date between effective_start_date and effective_end_date;
6319: --
6320: cursor csr_ass_row_id is