APPS.OZF_UTILITY_PVT dependencies on AMS_JTF_RS_EMP_V

Line 1402: FROM ams_jtf_rs_emp_v

1398: l_resource_name VARCHAR2(240);
1399:
1400: CURSOR c_resource_name IS
1401: SELECT full_name
1402: FROM ams_jtf_rs_emp_v
1403: WHERE resource_id = p_resource_id;
1404: BEGIN
1405: IF p_resource_id IS NULL THEN
1406: RETURN NULL;

Line 1645: FROM ams_jtf_rs_emp_v

1641: l_resource_id NUMBER;
1642:
1643: CURSOR c_resource IS
1644: SELECT resource_id
1645: FROM ams_jtf_rs_emp_v
1646: WHERE user_id = p_user_id;
1647: BEGIN
1648: OPEN c_resource;
1649: FETCH c_resource INTO l_resource_id;

Line 2802: FROM ams_jtf_rs_emp_v

2798: l_error_msg VARCHAR2(4000);
2799:
2800: CURSOR c_resource IS
2801: SELECT employee_id , user_id, category
2802: FROM ams_jtf_rs_emp_v
2803: WHERE resource_id = p_resource_id ;
2804:
2805: l_person_id number;
2806: l_user_id number;

Line 3121: FROM ams_jtf_rs_emp_v

3117: l_user_id NUMBER;
3118:
3119: CURSOR c_user IS
3120: SELECT user_id
3121: FROM ams_jtf_rs_emp_v
3122: WHERE resource_id = p_resource_id;
3123: BEGIN
3124: OPEN c_user;
3125: FETCH c_user INTO l_user_id;