APPS.HR_DELETE dependencies on PER_PEOPLE_F

Line 1291: (c_business_group_id per_people_f.business_group_id%TYPE)

1287: --
1288: l_exists varchar2(1);
1289: --
1290: cursor csr_get_person
1291: (c_business_group_id per_people_f.business_group_id%TYPE)
1292: is
1293: SELECT null
1294: FROM per_people_f
1295: WHERE business_group_id = c_business_group_id;

Line 1294: FROM per_people_f

1290: cursor csr_get_person
1291: (c_business_group_id per_people_f.business_group_id%TYPE)
1292: is
1293: SELECT null
1294: FROM per_people_f
1295: WHERE business_group_id = c_business_group_id;
1296: --
1297: cursor csr_get_aats
1298: (c_business_group_id

Line 1349: FROM per_people_f per

1345: WHERE
1346: SOURCE_TYPE = 'PPF'
1347: AND
1348: EXISTS (SELECT ''
1349: FROM per_people_f per
1350: WHERE per.person_id = pog.source_id
1351: AND per.business_group_id = p_business_group_id);
1352: --
1353: DELETE FROM per_people_extra_info pei

Line 1355: FROM per_people_f per

1351: AND per.business_group_id = p_business_group_id);
1352: --
1353: DELETE FROM per_people_extra_info pei
1354: WHERE EXISTS (SELECT ''
1355: FROM per_people_f per
1356: WHERE per.person_id = pei.person_id
1357: AND per.business_group_id = p_business_group_id);
1358: hr_utility.set_location(l_proc,55);
1359: --

Line 1380: DELETE FROM per_people_f pp

1376: DELETE FROM per_addresses pa
1377: WHERE pa.business_group_id = p_business_group_id;
1378: hr_utility.set_location(l_proc,100);
1379: --
1380: DELETE FROM per_people_f pp
1381: WHERE pp.business_group_id = p_business_group_id;
1382: hr_utility.set_location(l_proc,110);
1383: --
1384: end if;

Line 2213: FROM per_people_f pp,

2209: -- In development there are lots of business groups
2210: -- and otherwise it is not a very high cost.
2211: CURSOR pev IS
2212: SELECT pp.person_id
2213: FROM per_people_f pp,
2214: per_person_list pl
2215: WHERE pp.person_id = pl.person_id
2216: AND pp.business_group_id = p_business_group_id;
2217: BEGIN