APPS.GMS_WF_PKG dependencies on FND_USER

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 3241: FROM gms_notifications gn, fnd_user fu

3237: --Cursor to select corresponding user id attached to each award personnel .
3238: CURSOR gms_notification_cursor ( p_award_id NUMBER) IS
3239: SELECT gn.user_id ,
3240: fu.user_name
3241: FROM gms_notifications gn, fnd_user fu
3242: WHERE gn.user_id = fu.user_id
3243: AND event_type = 'INSTALLMENT_CLOSEOUT'
3244: AND award_id = p_award_id;
3245:

Line 3252: l_user_id fnd_user.user_id%TYPE;

3248: -- Declare the variables Used during the workflow process
3249:
3250: l_award_id gms_awards.award_id%TYPE;
3251: l_installment_id gms_installments.installment_id%TYPE;
3252: l_user_id fnd_user.user_id%TYPE;
3253: l_user_name fnd_user.user_name%TYPE;
3254: l_role_name VARCHAR2(1000);
3255: l_role_name_disp VARCHAR2(1000); -- Fix for NOCOPY related issues.
3256: --start bug fix 2204122 changed the width of var to 32000 from 4000--

Line 3253: l_user_name fnd_user.user_name%TYPE;

3249:
3250: l_award_id gms_awards.award_id%TYPE;
3251: l_installment_id gms_installments.installment_id%TYPE;
3252: l_user_id fnd_user.user_id%TYPE;
3253: l_user_name fnd_user.user_name%TYPE;
3254: l_role_name VARCHAR2(1000);
3255: l_role_name_disp VARCHAR2(1000); -- Fix for NOCOPY related issues.
3256: --start bug fix 2204122 changed the width of var to 32000 from 4000--
3257: l_role_users VARCHAR2(32000) := NULL;

Line 3400: from fnd_user fndu

3396: and gmsp.person_id = p_person_id;
3397: /*******
3398: and gmsp.person_id in
3399: (select fndu.employee_id
3400: from fnd_user fndu
3401: where fndu.user_id = p_user_id) ;
3402: *******/ --commented as per bug# 3495840 fix
3403:
3404: --Bug# 3495840

Line 3412: from fnd_user fndu

3408: --blank employee_id should be rejected
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