APPS.PV_PRGM_APPROVAL_PVT dependencies on PER_ALL_PEOPLE_F

Line 3249: FROM per_all_people_f per

3245: AND APPROVAL_STATUS_CODE IN ('PENDING_APPROVAL','PENDING_DEFAULT');
3246:
3247: CURSOR person_id_csr ( p_user_id NUMBER ) IS
3248: SELECT person_id ,full_name
3249: FROM per_all_people_f per
3250: , FND_USER usr
3251: WHERE user_id=p_user_id
3252: AND usr.person_party_id=per.party_id;
3253:

Line 4127: FROM per_all_people_f per

4123: AND res.user_id=fnd.user_id;
4124:
4125: CURSOR person_id_csr ( p_user_id NUMBER ) IS
4126: SELECT person_id ,full_name
4127: FROM per_all_people_f per
4128: , FND_USER usr
4129: WHERE user_id=p_user_id
4130: AND usr.person_party_id=per.party_id;
4131: