APPS.AMS_DMEXTRACT_PVT dependencies on AMS_EVENT_OFFERS_ALL_B

Line 1284: FROM ams_event_offers_all_b aeo, ams_dm_drv_stg_gt drv

1280: GROUP BY drv.party_id;
1281:
1282: CURSOR c_days_since_last_event IS
1283: SELECT (SYSDATE - MAX(aeo.event_start_date)), drv.party_id
1284: FROM ams_event_offers_all_b aeo, ams_dm_drv_stg_gt drv
1285: WHERE aeo.event_offer_id IN (SELECT aer.event_offer_id
1286: FROM ams_event_registrations aer
1287: -- WHERE aer.event_offer_id = aeo.event_offer_id
1288: WHERE aer.attendant_party_id = drv.party_id)

Line 1335: FROM ams_event_offers_all_b aeo, ams_dm_drv_stg_gt drv

1331: -- all references to party_id in ams_list_entries
1332: -- changed to list_entry_source_system_id
1333: CURSOR c_days_since_last_targeted IS
1334: SELECT (SYSDATE - MAX(aeo.event_start_date)), drv.party_id
1335: FROM ams_event_offers_all_b aeo, ams_dm_drv_stg_gt drv
1336: WHERE aeo.event_offer_id IN (SELECT aer.event_offer_id
1337: FROM ams_event_registrations aer
1338: -- WHERE aer.event_offer_id = aeo.event_offer_id
1339: WHERE aer.attendant_party_id = drv.party_id)

Line 1376: FROM ams_event_offers_all_b aeo,ams_dm_drv_stg_gt drv

1372: GROUP BY drv.party_id;
1373:
1374: CURSOR c_days_since_first_contact IS
1375: SELECT (SYSDATE - MIN(aeo.event_start_date)), drv.party_id
1376: FROM ams_event_offers_all_b aeo,ams_dm_drv_stg_gt drv
1377: WHERE aeo.event_offer_id IN (SELECT 1
1378: FROM ams_event_registrations aer
1379: -- WHERE aer.event_offer_id = aeo.event_offer_id
1380: WHERE aer.attendant_party_id = drv.party_id)

Line 1876: FROM ams_event_offers_all_b aeo, ams_dm_drv_stg_gt drv

1872: );
1873:
1874: CURSOR c_days_since_last_event IS
1875: SELECT (SYSDATE - MAX(aeo.event_start_date)), drv.party_id
1876: FROM ams_event_offers_all_b aeo, ams_dm_drv_stg_gt drv
1877: WHERE aeo.event_offer_id IN (SELECT aer.event_offer_id
1878: FROM ams_event_registrations aer
1879: WHERE aer.attendant_party_id in
1880: (select party_id

Line 1961: FROM ams_event_offers_all_b aeo, ams_dm_drv_stg_gt drv

1957: group by drv.party_id;
1958:
1959: CURSOR c_days_since_last_targeted IS
1960: SELECT (SYSDATE - MAX(aeo.event_start_date)), drv.party_id
1961: FROM ams_event_offers_all_b aeo, ams_dm_drv_stg_gt drv
1962: WHERE aeo.event_offer_id IN (SELECT aer.event_offer_id
1963: FROM ams_event_registrations aer
1964: WHERE aer.attendant_party_id in
1965: (select party_id

Line 2030: FROM ams_event_offers_all_b aeo, ams_dm_drv_stg_gt drv

2026: group by drv.party_id;
2027:
2028: CURSOR c_days_since_first_contact IS
2029: SELECT (SYSDATE - MIN(aeo.event_start_date)),drv.party_id
2030: FROM ams_event_offers_all_b aeo, ams_dm_drv_stg_gt drv
2031: WHERE aeo.event_offer_id IN (SELECT 1
2032: FROM ams_event_registrations aer
2033: WHERE aer.attendant_party_id in
2034: (select party_id