[Home] [Help]
1870: -- Bug 6156072: Base Bug 6045051: new procedure added to check if EI Date falls between active service periods
1871: -- of the contingent worker. This is similar to procedure check_termination
1872: procedure check_termination_for_cwk (p_person_id in per_all_people_f.person_id%type,
1873: p_ei_date in pa_expenditure_items_all.expenditure_item_date%type,
1874: x_actual_termination_date out nocopy per_periods_of_placement.actual_termination_date%type) IS
1875:
1876: cursor check_periods_of_service is
1877: select null
1878: from per_periods_of_placement
1874: x_actual_termination_date out nocopy per_periods_of_placement.actual_termination_date%type) IS
1875:
1876: cursor check_periods_of_service is
1877: select null
1878: from per_periods_of_placement
1879: where person_id = p_person_id
1880: and p_ei_date between date_start and nvl(actual_termination_date, p_ei_date);
1881:
1882: l_actual_termination_date per_periods_of_placement.actual_termination_date%type := NULL;
1878: from per_periods_of_placement
1879: where person_id = p_person_id
1880: and p_ei_date between date_start and nvl(actual_termination_date, p_ei_date);
1881:
1882: l_actual_termination_date per_periods_of_placement.actual_termination_date%type := NULL;
1883: begin
1884:
1885: open check_periods_of_service;
1886:
1888: if check_periods_of_service%notfound then
1889: begin
1890: select actual_termination_date into l_actual_termination_date from (
1891: select actual_termination_date
1892: from per_periods_of_placement
1893: where person_id = p_person_id
1894: and actual_termination_date < p_ei_date
1895: order by actual_termination_date desc)
1896: where rownum = 1;