APPS.PATC dependencies on PER_PERIODS_OF_PLACEMENT

Line 1318: from per_all_people_f p, per_periods_of_placement pop

1314: --{
1315: select distinct p.CURRENT_EMPLOYEE_FLAG ,
1316: p.CURRENT_NPW_FLAG
1317: into l_CURRENT_EMPLOYEE_FLAG , l_CURRENT_NPW_FLAG
1318: from per_all_people_f p, per_periods_of_placement pop
1319: where p.person_id = x_person_id
1320: and p.person_id = pop.person_id
1321: and p.effective_start_date = pop.date_start
1322: and x_ei_date between pop.date_start and

Line 1351: from per_all_people_f p, per_periods_of_placement pop

1347: --{
1348: select distinct p.CURRENT_EMPLOYEE_FLAG ,
1349: p.CURRENT_NPW_FLAG
1350: into l_CURRENT_EMPLOYEE_FLAG , l_CURRENT_NPW_FLAG
1351: from per_all_people_f p, per_periods_of_placement pop
1352: where p.person_id = x_person_id
1353: and p.person_id = pop.person_id
1354: and p.effective_start_date = pop.date_start
1355: and x_ei_date between pop.date_start and

Line 2368: x_actual_termination_date out nocopy per_periods_of_placement.actual_termination_date%type) IS

2364: -- Bug 6156072: Base Bug 6045051: new procedure added to check if EI Date falls between active service periods
2365: -- of the contingent worker. This is similar to procedure check_termination
2366: procedure check_termination_for_cwk (p_person_id in per_all_people_f.person_id%type,
2367: p_ei_date in pa_expenditure_items_all.expenditure_item_date%type,
2368: x_actual_termination_date out nocopy per_periods_of_placement.actual_termination_date%type) IS
2369:
2370: cursor check_periods_of_service is
2371: select null
2372: from per_periods_of_placement

Line 2372: from per_periods_of_placement

2368: x_actual_termination_date out nocopy per_periods_of_placement.actual_termination_date%type) IS
2369:
2370: cursor check_periods_of_service is
2371: select null
2372: from per_periods_of_placement
2373: where person_id = p_person_id
2374: and p_ei_date between date_start and nvl(actual_termination_date, p_ei_date);
2375:
2376: l_actual_termination_date per_periods_of_placement.actual_termination_date%type := NULL;

Line 2376: l_actual_termination_date per_periods_of_placement.actual_termination_date%type := NULL;

2372: from per_periods_of_placement
2373: where person_id = p_person_id
2374: and p_ei_date between date_start and nvl(actual_termination_date, p_ei_date);
2375:
2376: l_actual_termination_date per_periods_of_placement.actual_termination_date%type := NULL;
2377: begin
2378:
2379: open check_periods_of_service;
2380:

Line 2386: from per_periods_of_placement

2382: if check_periods_of_service%notfound then
2383: begin
2384: select actual_termination_date into l_actual_termination_date from (
2385: select actual_termination_date
2386: from per_periods_of_placement
2387: where person_id = p_person_id
2388: and actual_termination_date < p_ei_date
2389: order by actual_termination_date desc)
2390: where rownum = 1;