APPS.AMS_AGENDAS_PVT dependencies on AMS_EVENT_OFFERS_VL

Line 90: FROM ams_event_offers_vl

86:
87:
88: CURSOR c_event_coordinator(id_in IN NUMBER) IS
89: SELECT coordinator_id
90: FROM ams_event_offers_vl
91: WHERE event_offer_id = id_in;
92:
93: CURSOR c_event_id(id_in IN NUMBER) IS
94: SELECT parent_id

Line 106: FROM ams_event_offers_vl

102: WHERE agenda_id = p_agenda_rec.parent_id;
103:
104: CURSOR c_event_timezone(id_in IN NUMBER) IS
105: SELECT timezone_id
106: FROM ams_event_offers_vl
107: WHERE event_offer_id = id_in;
108:
109:
110:

Line 992: FROM ams_event_offers_vl

988: WHERE act_resource_used_by_id = l_session_id;
989:
990: CURSOR c_event_status IS
991: SELECT count(event_offer_id)
992: FROM ams_event_offers_vl
993: WHERE system_status_code IN ('COMPLETED', 'CANCELLED', 'ON_HOLD','ARCHIVED','CLOSED')
994: AND event_offer_id = ( SELECT parent_id
995: FROM ams_agendas_v
996: WHERE agenda_id = ( SELECT parent_id

Line 1663: 'ams_event_offers_vl',

1659: THEN
1660: IF p_agenda_rec.parent_id <> FND_API.g_miss_num
1661: AND p_agenda_rec.parent_id IS NOT NULL THEN
1662: IF AMS_Utility_PVT.check_fk_exists(
1663: 'ams_event_offers_vl',
1664: 'event_offer_id',
1665: p_agenda_rec.parent_id
1666: ) = FND_API.g_false
1667: THEN