APPS.PATC dependencies on PER_ALL_PEOPLE_F

Line 1226: from per_all_people_f p

1222:
1223: BEGIN
1224: select p.CURRENT_EMPLOYEE_FLAG , p.CURRENT_NPW_FLAG
1225: into l_CURRENT_EMPLOYEE_FLAG , l_CURRENT_NPW_FLAG
1226: from per_all_people_f p
1227: where p.person_id = x_person_id
1228: and trunc( x_ei_date) between trunc(p.effective_start_date) and trunc( p.effective_end_date) /* Added trunc() for bug 16451280 */
1229: and ((p.current_employee_flag = 'Y') OR (p.current_npw_flag = 'Y')); -- added for bug 7395534
1230: --and p.effective_start_date <= x_ei_date

Line 1278: from per_all_people_f p

1274: CLOSE cur_final_process_date;
1275: /*commented out for 12737060
1276: select p.CURRENT_EMPLOYEE_FLAG , p.CURRENT_NPW_FLAG
1277: into l_CURRENT_EMPLOYEE_FLAG , l_CURRENT_NPW_FLAG
1278: from per_all_people_f p
1279: where p.person_id = x_person_id
1280: and x_ei_date between p.effective_start_date and l_final_process_date
1281: and nvl(p.effective_end_date,l_final_process_date) >= l_final_process_date; --added for 11933246 */
1282: --and ((p.current_employee_flag = 'Y') OR (p.current_npw_flag = 'Y')); -- added for bug 7395534

Line 1289: from per_all_people_f p, per_periods_of_service pos

1285: /*Commeneted the changes for bug#13709322 */
1286:
1287: /*12737060 select distinct p.CURRENT_EMPLOYEE_FLAG , p.CURRENT_NPW_FLAG
1288: into l_CURRENT_EMPLOYEE_FLAG , l_CURRENT_NPW_FLAG
1289: from per_all_people_f p, per_periods_of_service pos
1290: where p.person_id = x_person_id
1291: and p.person_id = pos.person_id
1292: and p.effective_start_date = pos.date_start
1293: and x_ei_date between pos.date_start and

Line 1306: from per_all_people_f p, per_periods_of_service pos

1302: --{
1303: select distinct p.CURRENT_EMPLOYEE_FLAG ,
1304: p.CURRENT_NPW_FLAG
1305: into l_CURRENT_EMPLOYEE_FLAG , l_CURRENT_NPW_FLAG
1306: from per_all_people_f p, per_periods_of_service pos
1307: where p.person_id = x_person_id
1308: and p.person_id = pos.person_id
1309: and p.effective_start_date = pos.date_start
1310: and x_ei_date between pos.date_start and

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 1338: from per_all_people_f p, per_periods_of_service pos

1334: --{
1335:
1336: select distinct p.CURRENT_EMPLOYEE_FLAG , p.CURRENT_NPW_FLAG
1337: into l_CURRENT_EMPLOYEE_FLAG , l_CURRENT_NPW_FLAG
1338: from per_all_people_f p, per_periods_of_service pos
1339: where p.person_id = x_person_id
1340: and p.person_id = pos.person_id
1341: and p.effective_start_date = pos.date_start
1342: and x_ei_date between pos.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 2323: procedure check_termination (p_person_id in per_all_people_f.person_id%type,

2319:
2320:
2321: /* Added procedure check_termination for Bug#4604614 (BaseBug#4118885) */
2322:
2323: procedure check_termination (p_person_id in per_all_people_f.person_id%type,
2324: p_ei_date in pa_expenditure_items_all.expenditure_item_date%type,
2325: x_actual_termination_date out nocopy per_periods_of_service.actual_termination_date%type) IS
2326:
2327: cursor check_periods_of_service is

Line 2366: procedure check_termination_for_cwk (p_person_id in per_all_people_f.person_id%type,

2362:
2363: -- Bug 6156072: Base Bug 6045051: start
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