[Home] [Help]
1089: CURSOR period_end (p_asg_id in NUMBER,
1090: p_start_date in DATE) IS
1091: SELECT ptp.end_date
1092: FROM per_time_periods ptp,
1093: per_all_assignments_f paaf
1094: WHERE paaf.assignment_id = p_asg_id
1095: AND p_start_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date
1096: AND paaf.payroll_id = ptp.payroll_id
1097: AND p_start_date BETWEEN ptp.start_date AND ptp.end_date;
1101: ,p_term_rule varchar2) is
1102: select ppp.pay_proposal_id
1103: , ppp.multiple_components
1104: from per_pay_proposals ppp
1105: , per_all_assignments_f asg
1106: , per_pay_bases ppb
1107: , pay_element_types_f pet
1108: , pay_input_values_f piv
1109: where ppp.assignment_id=p_assignment_id
3122:
3123: cursor c_full_assignment(c_assignment_id number,
3124: c_effective_date date) is
3125: select *
3126: from per_all_assignments_f
3127: where assignment_id = c_assignment_id
3128: and c_effective_date between effective_start_date
3129: and effective_end_date;
3130:
4052: -- and which starts the day after the ATD...
4053: --
4054: select effective_end_date
4055: into l_new_effective_end_date
4056: from per_all_assignments_f
4057: where assignment_id = c_ass_rec.assignment_id
4058: and effective_start_date = p_actual_termination_date+1;
4059: --
4060: -- ...now update the assignment ending on ATD to have the selected
4059: --
4060: -- ...now update the assignment ending on ATD to have the selected
4061: -- end date...
4062: --
4063: update per_all_assignments_f
4064: set effective_end_date = l_new_effective_end_date
4065: where current of c_assignment;
4066: --
4067: -- ...now delete the assignment which starts on ATD+1...
4065: where current of c_assignment;
4066: --
4067: -- ...now delete the assignment which starts on ATD+1...
4068: --
4069: delete from per_all_assignments_f
4070: where assignment_id = c_ass_rec.assignment_id
4071: and effective_start_date = p_actual_termination_date +1;
4072: end if;
4073: -- end if;