APPS.PAAPIMP_PKG dependencies on PER_ALL_PEOPLE_F

Line 4278: FROM per_all_people_f emp

4274: write_log(LOG,'getting bus group id with emp id of : '||l_employee_id_tbl(i));
4275:
4276: SELECT emp.business_group_id
4277: INTO G_PER_BUS_GRP_ID
4278: FROM per_all_people_f emp
4279: WHERE emp.person_id = l_employee_id_tbl(i)
4280: AND l_ei_date_tbl(i) between trunc(emp.effective_start_date) and trunc(emp.effective_end_date);
4281:
4282: EXCEPTION

Line 6497: FROM per_all_people_f emp

6493: IF l_employee_id_tbl(i) <> 0 THEN
6494: Begin
6495: SELECT emp.business_group_id
6496: INTO G_PER_BUS_GRP_ID
6497: FROM per_all_people_f emp
6498: WHERE emp.person_id = l_employee_id_tbl(i)
6499: AND l_ei_date_tbl(i) between trunc(emp.effective_start_date) and
6500: trunc(emp.effective_end_date);
6501:

Line 7605: FROM per_all_people_f emp

7601: IF nvl(l_employee_id_tbl(i),0) <> 0 THEN
7602:
7603: SELECT emp.business_group_id
7604: INTO G_PER_BUS_GRP_ID
7605: FROM per_all_people_f emp
7606: WHERE emp.person_id = l_employee_id_tbl(i)
7607: AND l_ei_date_tbl(i) between trunc(emp.effective_start_date) and
7608: trunc(emp.effective_end_date);
7609:

Line 9894: FROM per_all_people_f emp

9890: IF l_employee_id_tbl(i) <> 0 THEN
9891: Begin
9892: SELECT emp.business_group_id
9893: INTO G_PER_BUS_GRP_ID
9894: FROM per_all_people_f emp
9895: WHERE emp.person_id = l_employee_id_tbl(i)
9896: AND l_ei_date_tbl(i) between trunc(emp.effective_start_date) and
9897: trunc(emp.effective_end_date);
9898:

Line 11717: FROM per_all_people_f emp

11713: write_log(LOG,'getting bus group id with emp id of : '||l_employee_id_tbl(i));
11714:
11715: SELECT emp.business_group_id
11716: INTO G_PER_BUS_GRP_ID
11717: FROM per_all_people_f emp
11718: WHERE emp.person_id = l_employee_id_tbl(i)
11719: AND l_ei_date_tbl(i) between trunc(emp.effective_start_date) and trunc(emp.effective_end_date);
11720:
11721: EXCEPTION