APPS.OZF_UTILITY_PVT dependencies on AMS_JTF_RS_EMP_V

Line 1377: FROM ams_jtf_rs_emp_v

1373: l_resource_name VARCHAR2(240);
1374:
1375: CURSOR c_resource_name IS
1376: SELECT full_name
1377: FROM ams_jtf_rs_emp_v
1378: WHERE resource_id = p_resource_id;
1379: BEGIN
1380: IF p_resource_id IS NULL THEN
1381: RETURN NULL;

Line 1620: FROM ams_jtf_rs_emp_v

1616: l_resource_id NUMBER;
1617:
1618: CURSOR c_resource IS
1619: SELECT resource_id
1620: FROM ams_jtf_rs_emp_v
1621: WHERE user_id = p_user_id;
1622: BEGIN
1623: OPEN c_resource;
1624: FETCH c_resource INTO l_resource_id;

Line 2780: FROM ams_jtf_rs_emp_v

2776: l_error_msg VARCHAR2(4000);
2777:
2778: CURSOR c_resource IS
2779: SELECT employee_id , user_id, category
2780: FROM ams_jtf_rs_emp_v
2781: WHERE resource_id = p_resource_id ;
2782:
2783: l_person_id number;
2784: l_user_id number;

Line 3099: FROM ams_jtf_rs_emp_v

3095: l_user_id NUMBER;
3096:
3097: CURSOR c_user IS
3098: SELECT user_id
3099: FROM ams_jtf_rs_emp_v
3100: WHERE resource_id = p_resource_id;
3101: BEGIN
3102: OPEN c_user;
3103: FETCH c_user INTO l_user_id;