APPS.HR_ASSIGNMENT_INTERNAL dependencies on PER_GRADE_SPINES_F

Line 2850: l_old_grade_id per_grade_spines_f.grade_id%Type;

2846: ,p_validation_start_date in date
2847: ,p_del_end_future_spp in out nocopy boolean) is
2848: --
2849: -- Local variables
2850: l_old_grade_id per_grade_spines_f.grade_id%Type;
2851: --
2852: l_proc varchar(72) := g_package||'cleanup_spp';
2853: -- Cursor to retrive the assignment records
2854: cursor csr_asg_details is

Line 2879: from per_grade_spines_f pgs,

2875: select pgs.grade_id,
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

Line 2892: from per_grade_spines_f pgs,

2888: -- Cursor to get the future SPP records, with effective_start_date >
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

Line 3030: ,p_grade_id in per_grade_spines_f.grade_id%Type

3026: --
3027: procedure delete_next_change_spp
3028: (p_assignment_id in per_all_assignments_f.assignment_id%Type
3029: ,p_placement_id in per_spinal_point_placements_f.placement_id%Type
3030: ,p_grade_id in per_grade_spines_f.grade_id%Type
3031: ,p_datetrack_mode in varchar2
3032: ,p_validation_start_date in date
3033: ,p_validation_end_date in date
3034: ,p_del_end_future_spp out nocopy boolean) is

Line 3062: from per_grade_spines_f pgs,

3058: order by spp.effective_start_date desc;
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

Line 4146: l_grade_spine_id per_grade_spines_f.grade_spine_id%Type;

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
4150: -- effective_end_date greater than the validation end date. This warning

Line 4189: from per_grade_spines_f pgs,

4185: -- Cursor to retrieve the first step (Minimum Grade Step) on the pay scale
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

Line 4206: from per_grade_spines_f pgs

4202: and sps2.effective_end_date);
4203: -- Cursor to check if the new Grade has been linked to a Pay Scale at any time
4204: cursor csr_grade_pay_scale_defined is
4205: select grade_spine_id
4206: from per_grade_spines_f pgs
4207: where grade_id = p_grade_id;
4208: -- Cursor to get the minimum effective_start_date of the SPP records
4209: cursor csr_min_spp_date is
4210: select min(spp.effective_start_date)