APPS.PV_PRGM_APPROVAL_PVT dependencies on JTF_RS_RESOURCE_EXTNS_VL

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 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 3257: , jtf_rs_resource_extns_vl res

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';
3261:

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 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