[Home] [Help]
498: RETURN DATE IS
499:
500: CURSOR pos_end_date_csr IS
501: SELECT actual_termination_date, final_process_date
502: FROM per_periods_of_service
503: WHERE period_of_service_id = p_period_of_service_id;
504:
505: l_return_date DATE;
506: l_final_process DATE;
1141: ,pos.actual_termination_date termination_date
1142: ,pos.final_process_date final_process_date
1143: FROM
1144: per_all_assignments_f asg
1145: ,per_periods_of_service pos
1146: ,per_all_assignments_f prev_asg
1147: WHERE asg.primary_flag = 'Y'
1148: AND prev_asg.primary_flag (+) = 'Y'
1149: AND asg.assignment_type = 'E'
1177: ,pos.actual_termination_date termination_date
1178: ,pos.final_process_date final_process_date
1179: FROM
1180: per_all_assignments_f asg
1181: ,per_periods_of_service pos
1182: WHERE asg.effective_end_date = pos.actual_termination_date
1183: AND (pos.actual_termination_date BETWEEN p_collect_from AND p_collect_to
1184: OR pos.final_process_date BETWEEN p_collect_from AND p_collect_to)
1185: AND asg.period_of_service_id = pos.period_of_service_id
1203: ,sub_pps.actual_termination_date actual_termination_date
1204: ,sub_pps.final_process_date final_process_date
1205: FROM
1206: per_all_assignments_f sub_asg
1207: ,per_periods_of_service pps
1208: ,per_periods_of_service sub_pps
1209: WHERE pps.final_process_date BETWEEN p_collect_from AND p_collect_to
1210: AND sub_asg.supervisor_id = pps.person_id
1211: AND sub_asg.period_of_service_id = sub_pps.period_of_service_id
1204: ,sub_pps.final_process_date final_process_date
1205: FROM
1206: per_all_assignments_f sub_asg
1207: ,per_periods_of_service pps
1208: ,per_periods_of_service sub_pps
1209: WHERE pps.final_process_date BETWEEN p_collect_from AND p_collect_to
1210: AND sub_asg.supervisor_id = pps.person_id
1211: AND sub_asg.period_of_service_id = sub_pps.period_of_service_id
1212: AND sub_asg.assignment_type = 'E'