[Home] [Help]
1071: CURSOR period_end (p_asg_id in NUMBER,
1072: p_start_date in DATE) IS
1073: SELECT ptp.end_date
1074: FROM per_time_periods ptp,
1075: per_all_assignments_f paaf
1076: WHERE paaf.assignment_id = p_asg_id
1077: AND p_start_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date
1078: AND paaf.payroll_id = ptp.payroll_id
1079: AND p_start_date BETWEEN ptp.start_date AND ptp.end_date;
1083: ,p_term_rule varchar2) is
1084: select ppp.pay_proposal_id
1085: , ppp.multiple_components
1086: from per_pay_proposals ppp
1087: , per_all_assignments_f asg
1088: , per_pay_bases ppb
1089: , pay_element_types_f pet
1090: , pay_input_values_f piv
1091: where ppp.assignment_id=p_assignment_id
3104:
3105: cursor c_full_assignment(c_assignment_id number,
3106: c_effective_date date) is
3107: select *
3108: from per_all_assignments_f
3109: where assignment_id = c_assignment_id
3110: and c_effective_date between effective_start_date
3111: and effective_end_date;
3112:
3902: -- and which starts the day after the ATD...
3903: --
3904: select effective_end_date
3905: into l_new_effective_end_date
3906: from per_all_assignments_f
3907: where assignment_id = c_ass_rec.assignment_id
3908: and effective_start_date = p_actual_termination_date+1;
3909: --
3910: -- ...now update the assignment ending on ATD to have the selected
3909: --
3910: -- ...now update the assignment ending on ATD to have the selected
3911: -- end date...
3912: --
3913: update per_all_assignments_f
3914: set effective_end_date = l_new_effective_end_date
3915: where current of c_assignment;
3916: --
3917: -- ...now delete the assignment which starts on ATD+1...
3915: where current of c_assignment;
3916: --
3917: -- ...now delete the assignment which starts on ATD+1...
3918: --
3919: delete from per_all_assignments_f
3920: where assignment_id = c_ass_rec.assignment_id
3921: and effective_start_date = p_actual_termination_date +1;
3922: end if;
3923: -- end if;