APPS.AMS_DMEXTRACT_PVT dependencies on AMS_EVENT_REGISTRATIONS

Line 1286: FROM ams_event_registrations aer

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)
1289: GROUP BY drv.party_id;
1290:

Line 1337: FROM ams_event_registrations aer

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)
1340: GROUP BY drv.party_id;
1341:

Line 1378: FROM ams_event_registrations aer

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)
1381: GROUP BY drv.party_id;
1382:

Line 1878: FROM ams_event_registrations aer

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
1881: from hz_relationships hpr
1882: where object_id=drv.party_id

Line 1963: FROM ams_event_registrations aer

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
1966: from hz_relationships hpr
1967: where object_id=drv.party_id

Line 2032: FROM ams_event_registrations aer

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
2035: from hz_relationships hpr
2036: where object_id=drv.party_id