APPS.GMS_WF_PKG dependencies on PER_ALL_PEOPLE_F

Line 551: FROM per_all_people_f pp where pp.person_id = p.person_id

547: , f.user_name
548: , p.first_name||' '||p.last_name
549: FROM fnd_user f, per_people_f p /*Bug 5122724 */
550: WHERE p.effective_start_date = (SELECT min(pp.effective_start_date)
551: FROM per_all_people_f pp where pp.person_id = p.person_id
552: AND pp.effective_end_date >=trunc(sysdate))
553: AND ((p.employee_number is not null) OR (p.npw_number is not null))
554: AND f.employee_id = p_baseliner_id
555: AND f.employee_id = p.person_id;

Line 2082: from per_all_people_f pp

2078: is
2079: select p.first_name||' '||p.last_name /*Bug 5122724 */
2080: from fnd_user f, per_people_f p
2081: where p.effective_start_date = (select min(pp.effective_start_date)
2082: from per_all_people_f pp
2083: where pp.person_id = p.person_id
2084: and pp.effective_end_date >=trunc(sysdate))
2085: and ((p.employee_number is not null) OR (p.npw_number is not null))
2086: and user_id = FND_GLOBAL.User_Id

Line 2600: from per_all_people_f pp

2596: is
2597: select p.first_name||' '||p.last_name /*Bug 5122724 */
2598: from fnd_user f, per_people_f p
2599: where p.effective_start_date = (select min(pp.effective_start_date)
2600: from per_all_people_f pp
2601: where pp.person_id = p.person_id
2602: and pp.effective_end_date >=trunc(sysdate))
2603: and ((p.employee_number is not null) OR (p.npw_number is not null))
2604: and user_id = FND_GLOBAL.User_Id

Line 3415: from per_all_people_f pp

3411: select fndu.employee_id /*Bug 5122724 */
3412: from fnd_user fndu
3413: ,per_people_f p
3414: where p.effective_start_date = (select min(pp.effective_start_date)
3415: from per_all_people_f pp
3416: where pp.person_id = p.person_id
3417: and pp.effective_end_date >=trunc(sysdate))
3418: and ((p.employee_number is not null) OR (p.npw_number is not null))
3419: and p.person_id = fndu.employee_id