APPS.HR_ASSIGNMENT_INTERNAL dependencies on PER_GRADE_SPINES_F

Line 2983: l_old_grade_id per_grade_spines_f.grade_id%Type;

2979: ,p_validation_start_date in date
2980: ,p_del_end_future_spp in out nocopy boolean) is
2981: --
2982: -- Local variables
2983: l_old_grade_id per_grade_spines_f.grade_id%Type;
2984: --
2985: l_proc varchar(72) := g_package||'cleanup_spp';
2986: -- Cursor to retrive the assignment records
2987: cursor csr_asg_details is

Line 3012: from per_grade_spines_f pgs,

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

Line 3025: from per_grade_spines_f pgs,

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

Line 3163: ,p_grade_id in per_grade_spines_f.grade_id%Type

3159: --
3160: procedure delete_next_change_spp
3161: (p_assignment_id in per_all_assignments_f.assignment_id%Type
3162: ,p_placement_id in per_spinal_point_placements_f.placement_id%Type
3163: ,p_grade_id in per_grade_spines_f.grade_id%Type
3164: ,p_datetrack_mode in varchar2
3165: ,p_validation_start_date in date
3166: ,p_validation_end_date in date
3167: ,p_del_end_future_spp out nocopy boolean) is

Line 3195: from per_grade_spines_f pgs,

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

Line 4279: l_grade_spine_id per_grade_spines_f.grade_spine_id%Type;

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

Line 4322: from per_grade_spines_f pgs,

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

Line 4339: from per_grade_spines_f pgs

4335: and sps2.effective_end_date);
4336: -- Cursor to check if the new Grade has been linked to a Pay Scale at any time
4337: cursor csr_grade_pay_scale_defined is
4338: select grade_spine_id
4339: from per_grade_spines_f pgs
4340: where grade_id = p_grade_id;
4341: -- Cursor to get the minimum effective_start_date of the SPP records
4342: cursor csr_min_spp_date is
4343: select min(spp.effective_start_date)