APPS.AMS_EVENTHEADER_PVT dependencies on AMS_JTF_RS_EMP_V

Line 94: FROM ams_jtf_rs_emp_v

90: AND system_status_type = 'AMS_EVENT_AGENDA_STATUS';
91:
92: CURSOR get_res_id(l_user_id IN NUMBER) IS
93: SELECT resource_id
94: FROM ams_jtf_rs_emp_v
95: WHERE user_id = l_user_id;
96:
97: BEGIN
98:

Line 694: FROM ams_jtf_rs_emp_v

690: l_user_id NUMBER;
691: l_res_id NUMBER;
692: CURSOR get_res_id(l_user_id IN NUMBER) IS
693: SELECT resource_id
694: FROM ams_jtf_rs_emp_v
695: WHERE user_id = l_user_id;
696:
697: CURSOR get_parent_header_info(l_evh_id IN NUMBER) IS
698: SELECT event_level,parent_event_header_id

Line 1048: FROM ams_jtf_rs_emp_v

1044: AND system_status_type = 'AMS_EVENT_AGENDA_STATUS';
1045:
1046: CURSOR get_res_id(l_user_id IN NUMBER) IS
1047: SELECT resource_id
1048: FROM ams_jtf_rs_emp_v
1049: WHERE user_id = l_user_id;
1050:
1051: CURSOR c_bdgt_line_yn(id_in IN NUMBER, objtype_in IN VARCHAR2) IS
1052: SELECT count(*)

Line 2286: 'ams_jtf_rs_emp_v',

2282: END IF;
2283: ----------------------- owner_user_id ------------------------
2284: IF p_evh_rec.owner_user_id <> FND_API.g_miss_num THEN
2285: IF AMS_Utility_PVT.check_fk_exists(
2286: 'ams_jtf_rs_emp_v',
2287: 'resource_id',
2288: p_evh_rec.owner_user_id
2289: ) = FND_API.g_false
2290: THEN