APPS.AMS_EVENTOFFER_PVT dependencies on AMS_JTF_RS_EMP_V

Line 325: FROM ams_jtf_rs_emp_v

321: l_ovn NUMBER(9) := 1;
322:
323: CURSOR get_res_id(l_user_id IN NUMBER) IS
324: SELECT resource_id
325: FROM ams_jtf_rs_emp_v
326: WHERE user_id = l_user_id;
327:
328: CURSOR c_evo_seq IS
329: SELECT ams_event_offers_all_b_s.NEXTVAL

Line 1178: FROM ams_jtf_rs_emp_v

1174: WHERE EVENT_OFFER_ID = id_in;
1175:
1176: CURSOR get_res_id(l_user_id IN NUMBER) IS
1177: SELECT resource_id
1178: FROM ams_jtf_rs_emp_v
1179: WHERE user_id = l_user_id;
1180:
1181: CURSOR get_parent_offer_info(l_evo_id IN NUMBER) IS
1182: SELECT event_level,parent_event_offer_id

Line 1602: FROM ams_jtf_rs_emp_v

1598: AND qph.currency_code = curr_code;
1599:
1600: CURSOR get_res_id(l_user_id IN NUMBER) IS
1601: SELECT resource_id
1602: FROM ams_jtf_rs_emp_v
1603: WHERE user_id = l_user_id;
1604:
1605: CURSOR c_location(id_in IN NUMBER) IS
1606: SELECT loc.address1, loc.address2, loc.city, loc.state, loc.country

Line 3299: -- modified sugupta use ams_jtf_rs_emp_v instead of ams_jtf_rs_emp_v

3295: BEGIN
3296: x_return_status := FND_API.g_ret_sts_success;
3297:
3298: ----------------------- owner_user_id ------------------------
3299: -- modified sugupta use ams_jtf_rs_emp_v instead of ams_jtf_rs_emp_v
3300: IF p_evo_rec.owner_user_id <> FND_API.g_miss_num AND
3301: p_evo_rec.owner_user_id is NOT NULL
3302: THEN
3303: IF AMS_Utility_PVT.check_fk_exists(

Line 3304: 'ams_jtf_rs_emp_v',

3300: IF p_evo_rec.owner_user_id <> FND_API.g_miss_num AND
3301: p_evo_rec.owner_user_id is NOT NULL
3302: THEN
3303: IF AMS_Utility_PVT.check_fk_exists(
3304: 'ams_jtf_rs_emp_v',
3305: 'resource_id',
3306: p_evo_rec.owner_user_id
3307: ) = FND_API.g_false
3308: THEN