APPS.AMS_ACTRESOURCE_PVT dependencies on AMS_EVENT_OFFERS_ALL_B

Line 1187: l_table_name := 'AMS_EVENT_OFFERS_ALL_B';

1183: l_table_name := 'AMS_AGENDAS_B';
1184: l_pk_name := 'AGENDA_ID';
1185: ELSIF (p_act_Resource_rec.arc_act_resource_used_by = 'EVEO' OR p_act_Resource_rec.arc_act_resource_used_by = 'EONE')
1186: THEN
1187: l_table_name := 'AMS_EVENT_OFFERS_ALL_B';
1188: l_pk_name := 'EVENT_OFFER_ID';
1189: END IF;
1190:
1191: l_pk_value := p_act_Resource_rec.act_resource_used_by_id;

Line 1369: FROM ams_event_offers_all_b

1365: AND agenda_TYPE = type_in;
1366:
1367: CURSOR get_event_date (id_in in NUMBER,type_in IN VARCHAR2)is
1368: SELECT event_start_date_time, event_end_date_time
1369: FROM ams_event_offers_all_b
1370: WHERE event_offer_id = id_in
1371: AND event_object_type = type_in;
1372:
1373: CURSOR c_event_status IS

Line 1375: FROM ams_event_offers_all_b

1371: AND event_object_type = type_in;
1372:
1373: CURSOR c_event_status IS
1374: SELECT count(event_offer_id)
1375: FROM ams_event_offers_all_b
1376: WHERE system_status_code IN ('COMPLETED', 'CANCELLED', 'ON_HOLD','ARCHIVED','CLOSED')
1377: AND event_offer_id = p_act_Resource_rec.act_resource_used_by_id;
1378:
1379: CURSOR c_parent_status IS

Line 1381: FROM ams_event_offers_all_b

1377: AND event_offer_id = p_act_Resource_rec.act_resource_used_by_id;
1378:
1379: CURSOR c_parent_status IS
1380: SELECT count(event_offer_id)
1381: FROM ams_event_offers_all_b
1382: WHERE system_status_code IN ('COMPLETED', 'CANCELLED', 'ON_HOLD','ARCHIVED','CLOSED')
1383: AND event_offer_id = ( SELECT parent_id
1384: FROM ams_agendas_b
1385: WHERE agenda_id = ( SELECT parent_id