APPS.AMS_EVENTOFFER_PVT dependencies on AMS_EVENT_HEADERS_ALL_B

Line 3362: 'ams_event_headers_all_b',

3358: IF p_evo_rec.event_header_id <> FND_API.g_miss_num AND
3359: p_evo_rec.event_header_id is NOT NULL THEN
3360: IF p_evo_rec.EVENT_STANDALONE_FLAG = 'N'THEN
3361: IF AMS_Utility_PVT.check_fk_exists(
3362: 'ams_event_headers_all_b',
3363: 'event_header_id',
3364: p_evo_rec.event_header_id
3365: ) = FND_API.g_false
3366: THEN

Line 7006: FROM ams_event_headers_all_b

7002:
7003: CURSOR c_event IS
7004: -- SELECT active_from_date, active_to_date FROM ams_event_headers_v
7005: SELECT active_from_date, active_to_date
7006: FROM ams_event_headers_all_b
7007: WHERE event_header_id = p_evo_rec.event_header_id;
7008:
7009: CURSOR c_event_schedule IS
7010: -- SELECT event_start_date, event_end_date FROM ams_event_offers_v

Line 7135: FROM ams_event_headers_all_b

7131:
7132: CURSOR c_event IS
7133: -- SELECT system_status_code FROM ams_event_headers_v
7134: SELECT system_status_code
7135: FROM ams_event_headers_all_b
7136: WHERE event_header_id = p_evo_rec.event_header_id;
7137:
7138:
7139: BEGIN