eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PV_PRGM_APPROVAL_PVT dependencies on FND_USER

Line 132: FROM fnd_user

128: FUNCTION getUserId(p_user_name IN VARCHAR2)
129: RETURN NUMBER IS
130: CURSOR user_csr(uname VARCHAR2) IS
131: SELECT user_id
132: FROM fnd_user
133: WHERE user_name=uname;
134: l_user_id NUMBER;
135: BEGIN
136: OPEN user_csr(p_user_name);

Line 3226: FROM jtf_rs_resource_extns_vl res,fnd_user fnd

3222: AND arc_appr_for_entity_code='ENRQ';
3223:
3224: CURSOR c_resource_per_cur(p_appr_id NUMBER) IS
3225: SELECT res.resource_id,res.resource_name
3226: FROM jtf_rs_resource_extns_vl res,fnd_user fnd
3227: WHERE fnd.employee_id = p_appr_id
3228: AND res.user_id=fnd.user_id;
3229:
3230: CURSOR c_resource_usr_cur(p_appr_id NUMBER) IS

Line 3228: AND res.user_id=fnd.user_id;

3224: CURSOR c_resource_per_cur(p_appr_id NUMBER) IS
3225: SELECT res.resource_id,res.resource_name
3226: FROM jtf_rs_resource_extns_vl res,fnd_user fnd
3227: WHERE fnd.employee_id = p_appr_id
3228: AND res.user_id=fnd.user_id;
3229:
3230: CURSOR c_resource_usr_cur(p_appr_id NUMBER) IS
3231: SELECT res.resource_id,res.resource_name
3232: FROM jtf_rs_resource_extns_vl res,fnd_user fnd

Line 3232: FROM jtf_rs_resource_extns_vl res,fnd_user fnd

3228: AND res.user_id=fnd.user_id;
3229:
3230: CURSOR c_resource_usr_cur(p_appr_id NUMBER) IS
3231: SELECT res.resource_id,res.resource_name
3232: FROM jtf_rs_resource_extns_vl res,fnd_user fnd
3233: WHERE fnd.user_id = p_appr_id
3234: AND res.user_id=fnd.user_id;
3235:
3236: CURSOR c_enrl_cur ( enrl_id NUMBER ) IS

Line 3233: WHERE fnd.user_id = p_appr_id

3229:
3230: CURSOR c_resource_usr_cur(p_appr_id NUMBER) IS
3231: SELECT res.resource_id,res.resource_name
3232: FROM jtf_rs_resource_extns_vl res,fnd_user fnd
3233: WHERE fnd.user_id = p_appr_id
3234: AND res.user_id=fnd.user_id;
3235:
3236: CURSOR c_enrl_cur ( enrl_id NUMBER ) IS
3237: SELECT partner_id

Line 3234: AND res.user_id=fnd.user_id;

3230: CURSOR c_resource_usr_cur(p_appr_id NUMBER) IS
3231: SELECT res.resource_id,res.resource_name
3232: FROM jtf_rs_resource_extns_vl res,fnd_user fnd
3233: WHERE fnd.user_id = p_appr_id
3234: AND res.user_id=fnd.user_id;
3235:
3236: CURSOR c_enrl_cur ( enrl_id NUMBER ) IS
3237: SELECT partner_id
3238: FROM pv_pg_enrl_requests

Line 3250: , FND_USER usr

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:
3254: CURSOR is_partner_usr_csr( p_usr_id NUMBER ) IS

Line 3256: FROM fnd_user usr

3252: AND usr.person_party_id=per.party_id;
3253:
3254: CURSOR is_partner_usr_csr( p_usr_id NUMBER ) IS
3255: SELECT 'Y'
3256: FROM fnd_user usr
3257: , jtf_rs_resource_extns_vl res
3258: WHERE usr.user_id=p_usr_id
3259: AND usr.user_id=res.user_id
3260: AND res.category='PARTY';

Line 4115: FROM jtf_rs_resource_extns_vl res,fnd_user fnd

4111: WHERE enrl_request_id=p_enrl_req_id;
4112:
4113: CURSOR c_resource_per_cur(p_appr_id NUMBER) IS
4114: SELECT res.resource_id,res.resource_name
4115: FROM jtf_rs_resource_extns_vl res,fnd_user fnd
4116: WHERE fnd.employee_id = p_appr_id
4117: AND res.user_id=fnd.user_id;
4118:
4119: CURSOR c_resource_usr_cur(p_appr_id NUMBER) IS

Line 4117: AND res.user_id=fnd.user_id;

4113: CURSOR c_resource_per_cur(p_appr_id NUMBER) IS
4114: SELECT res.resource_id,res.resource_name
4115: FROM jtf_rs_resource_extns_vl res,fnd_user fnd
4116: WHERE fnd.employee_id = p_appr_id
4117: AND res.user_id=fnd.user_id;
4118:
4119: CURSOR c_resource_usr_cur(p_appr_id NUMBER) IS
4120: SELECT res.resource_id,res.resource_name
4121: FROM jtf_rs_resource_extns_vl res,fnd_user fnd

Line 4121: FROM jtf_rs_resource_extns_vl res,fnd_user fnd

4117: AND res.user_id=fnd.user_id;
4118:
4119: CURSOR c_resource_usr_cur(p_appr_id NUMBER) IS
4120: SELECT res.resource_id,res.resource_name
4121: FROM jtf_rs_resource_extns_vl res,fnd_user fnd
4122: WHERE fnd.user_id = p_appr_id
4123: AND res.user_id=fnd.user_id;
4124:
4125: CURSOR person_id_csr ( p_user_id NUMBER ) IS

Line 4122: WHERE fnd.user_id = p_appr_id

4118:
4119: CURSOR c_resource_usr_cur(p_appr_id NUMBER) IS
4120: SELECT res.resource_id,res.resource_name
4121: FROM jtf_rs_resource_extns_vl res,fnd_user fnd
4122: WHERE fnd.user_id = p_appr_id
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

Line 4123: AND res.user_id=fnd.user_id;

4119: CURSOR c_resource_usr_cur(p_appr_id NUMBER) IS
4120: SELECT res.resource_id,res.resource_name
4121: FROM jtf_rs_resource_extns_vl res,fnd_user fnd
4122: WHERE fnd.user_id = p_appr_id
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

Line 4128: , FND_USER usr

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:
4132: BEGIN