APPS.PA_STAFFED_ASSIGNMENT_PVT dependencies on PER_ALL_PEOPLE_F

Line 161: FROM per_all_people_f

157: AND resource_id = l_assignment_rec.resource_id;
158:
159: CURSOR check_future_dated_employee IS
160: SELECT 'X'
161: FROM per_all_people_f
162: WHERE person_id = l_person_id_tmp
163: AND effective_start_date <= sysdate
164: AND rownum = 1;
165:

Line 677: FROM per_all_people_f peo

673: AND prd.resource_effective_end_date ;
674:
675: SELECT decode(nvl(peo.employee_number,0), 0,'CWK','EMP')
676: INTO l_person_type_code
677: FROM per_all_people_f peo
678: WHERE peo.person_id = l_person_id_tmp
679: AND l_assignment_rec.start_date BETWEEN peo.effective_start_date
680: AND peo.effective_end_date ;
681:

Line 696: FROM per_all_people_f peo

692: AND ROWNUM = 1;
693:
694: SELECT decode(peo.current_employee_flag, 'Y', 'EMP', 'CWK')
695: INTO l_person_type_code
696: FROM per_all_people_f peo
697: WHERE peo.person_id = l_person_id_tmp
698: AND l_assignment_rec.start_date BETWEEN peo.effective_start_date
699: AND peo.effective_end_date
700: AND ROWNUM = 1;

Line 1617: FROM per_all_people_f peo

1613: END IF;
1614:
1615: SELECT decode(nvl(peo.employee_number,0), 0,'CWK','EMP')
1616: INTO l_person_type_code
1617: FROM per_all_people_f peo
1618: WHERE peo.person_id = l_person_id_tmp
1619: AND l_assignment_rec.start_date BETWEEN peo.effective_start_date
1620: AND peo.effective_end_date ;
1621:

Line 1642: FROM per_all_people_f peo, pa_project_assignments pa

1638: END IF;
1639:
1640: SELECT decode(peo.current_employee_flag, 'Y', 'EMP', 'CWK')
1641: INTO l_person_type_code
1642: FROM per_all_people_f peo, pa_project_assignments pa
1643: WHERE peo.person_id = l_person_id_tmp
1644: AND pa.assignment_id = l_assignment_rec.assignment_id
1645: AND pa.start_date BETWEEN peo.effective_start_date
1646: AND peo.effective_end_date