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 3448: from per_all_people_f pp

3444: select fndu.employee_id /*Bug 5122724 */
3445: from fnd_user fndu
3446: ,per_people_f p
3447: where p.effective_start_date = (select min(pp.effective_start_date)
3448: from per_all_people_f pp
3449: where pp.person_id = p.person_id
3450: and pp.effective_end_date >=trunc(sysdate))
3451: and ((p.employee_number is not null) OR (p.npw_number is not null))
3452: and p.person_id = fndu.employee_id