APPS.PAAPIMP_PKG dependencies on PER_ALL_PEOPLE_F

Line 3176: FROM per_all_people_f emp

3172: write_log(LOG,'getting bus group id with emp id of : '||l_employee_id_tbl(i));
3173:
3174: SELECT emp.business_group_id
3175: INTO G_PER_BUS_GRP_ID
3176: FROM per_all_people_f emp
3177: WHERE emp.person_id = l_employee_id_tbl(i)
3178: AND l_ei_date_tbl(i) between trunc(emp.effective_start_date) and trunc(emp.effective_end_date);
3179:
3180: EXCEPTION

Line 5179: FROM per_all_people_f emp

5175: IF l_employee_id_tbl(i) <> 0 THEN
5176: Begin
5177: SELECT emp.business_group_id
5178: INTO G_PER_BUS_GRP_ID
5179: FROM per_all_people_f emp
5180: WHERE emp.person_id = l_employee_id_tbl(i)
5181: AND l_ei_date_tbl(i) between trunc(emp.effective_start_date) and
5182: trunc(emp.effective_end_date);
5183:

Line 6147: FROM per_all_people_f emp

6143: IF nvl(l_employee_id_tbl(i),0) <> 0 THEN
6144:
6145: SELECT emp.business_group_id
6146: INTO G_PER_BUS_GRP_ID
6147: FROM per_all_people_f emp
6148: WHERE emp.person_id = l_employee_id_tbl(i)
6149: AND l_ei_date_tbl(i) between trunc(emp.effective_start_date) and
6150: trunc(emp.effective_end_date);
6151:

Line 8184: FROM per_all_people_f emp

8180: IF l_employee_id_tbl(i) <> 0 THEN
8181: Begin
8182: SELECT emp.business_group_id
8183: INTO G_PER_BUS_GRP_ID
8184: FROM per_all_people_f emp
8185: WHERE emp.person_id = l_employee_id_tbl(i)
8186: AND l_ei_date_tbl(i) between trunc(emp.effective_start_date) and
8187: trunc(emp.effective_end_date);
8188:

Line 9962: FROM per_all_people_f emp

9958: write_log(LOG,'getting bus group id with emp id of : '||l_employee_id_tbl(i));
9959:
9960: SELECT emp.business_group_id
9961: INTO G_PER_BUS_GRP_ID
9962: FROM per_all_people_f emp
9963: WHERE emp.person_id = l_employee_id_tbl(i)
9964: AND l_ei_date_tbl(i) between trunc(emp.effective_start_date) and trunc(emp.effective_end_date);
9965:
9966: EXCEPTION