APPS.AMS_ASSOCIATIONS_PVT dependencies on AMS_EVENT_HEADERS_ALL_B

Line 1178: THEN l_foreign_table := 'AMS_EVENT_HEADERS_ALL_B';

1174:
1175: BEGIN
1176:
1177: IF p_master_type = 'EVEH'
1178: THEN l_foreign_table := 'AMS_EVENT_HEADERS_ALL_B';
1179: l_foreign_table_id := 'EVENT_HEADER_ID';
1180: ELSIF p_master_type = 'EVEO'
1181: THEN l_foreign_table := 'AMS_EVENT_OFFERS_ALL_B';
1182: l_foreign_table_id := 'EVENT_OFFER_ID';

Line 1214: THEN l_foreign_table := 'AMS_EVENT_HEADERS_ALL_B';

1210: return FND_API.g_false;
1211: END IF;
1212:
1213: IF p_using_type = 'EVEH'
1214: THEN l_foreign_table := 'AMS_EVENT_HEADERS_ALL_B';
1215: l_foreign_table_id := 'EVENT_HEADER_ID';
1216: ELSIF p_using_type = 'EVEO'
1217: THEN l_foreign_table := 'AMS_EVENT_OFFERS_ALL_B';
1218: l_foreign_table_id := 'EVENT_OFFER_ID';

Line 1626: FROM ams_event_headers_all_b

1622:
1623: CURSOR c_eveh_end_Date(l_event_id IN NUMBER)
1624: IS
1625: SELECT active_to_date
1626: FROM ams_event_headers_all_b
1627: WHERE event_header_id = l_event_id;
1628:
1629: CURSOR c_eveo_end_date(l_event_offer_id IN NUMBER)
1630: IS