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 708: FROM per_all_people_f peo

704: AND prd.resource_effective_end_date ;
705:
706: SELECT decode(nvl(peo.employee_number,0), 0,'CWK','EMP')
707: INTO l_person_type_code
708: FROM per_all_people_f peo
709: WHERE peo.person_id = l_person_id_tmp
710: AND l_assignment_rec.start_date BETWEEN peo.effective_start_date
711: AND peo.effective_end_date ;
712:

Line 727: FROM per_all_people_f peo

723: AND ROWNUM = 1;
724:
725: SELECT decode(peo.current_employee_flag, 'Y', 'EMP', 'CWK')
726: INTO l_person_type_code
727: FROM per_all_people_f peo
728: WHERE peo.person_id = l_person_id_tmp
729: AND l_assignment_rec.start_date BETWEEN peo.effective_start_date
730: AND peo.effective_end_date
731: AND ROWNUM = 1;

Line 1648: FROM per_all_people_f peo

1644: END IF;
1645:
1646: SELECT decode(nvl(peo.employee_number,0), 0,'CWK','EMP')
1647: INTO l_person_type_code
1648: FROM per_all_people_f peo
1649: WHERE peo.person_id = l_person_id_tmp
1650: AND l_assignment_rec.start_date BETWEEN peo.effective_start_date
1651: AND peo.effective_end_date ;
1652:

Line 1673: FROM per_all_people_f peo, pa_project_assignments pa

1669: END IF;
1670:
1671: SELECT decode(peo.current_employee_flag, 'Y', 'EMP', 'CWK')
1672: INTO l_person_type_code
1673: FROM per_all_people_f peo, pa_project_assignments pa
1674: WHERE peo.person_id = l_person_id_tmp
1675: AND pa.assignment_id = l_assignment_rec.assignment_id
1676: AND pa.start_date BETWEEN peo.effective_start_date
1677: AND peo.effective_end_date