APPS.GMS_WF_PKG dependencies on PER_PEOPLE_F

Line 549: FROM fnd_user f, per_people_f p /*Bug 5122724 */

545: IS
546: SELECT f.user_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))

Line 2080: from fnd_user f, per_people_f p

2076:
2077: cursor l_starter_full_name_csr
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))

Line 2598: from fnd_user f, per_people_f p

2594:
2595: cursor l_starter_full_name_csr
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))

Line 3413: ,per_people_f p

3409: cursor is_user_active
3410: is
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))