[Home] [Help]
2078: --
2079: cursor csr_get_eff_date(p_assgn_id in number, p_eff_date in date) is
2080: select nvl(ppos.final_process_date,p_eff_date)
2081: from per_assignments_f asg,
2082: per_periods_of_service ppos
2083: where asg.assignment_id = p_assgn_id
2084: and ppos.period_of_service_id = asg.period_of_service_id
2085: and nvl(ppos.final_process_date,p_eff_date) between asg.effective_start_date and asg.effective_end_date;
2086: