eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_EVHRULES_PVT dependencies on AMS_EVENT_REGISTRATIONS

Line 1372: FROM ams_event_registrations

1368: SELECT registrant_party_id
1369: , registrant_contact_id
1370: , attendant_party_id
1371: , attendant_contact_id
1372: FROM ams_event_registrations
1373: WHERE event_offer_id = event_id_in
1374: AND system_status_code = 'REGISTERED' -- In future when we kill the REGISTERED status and leave ENROLLED, change this to ENROLLED.
1375: AND active_flag = 'Y';
1376:

Line 1384: FROM ams_event_registrations

1380: SELECT registrant_party_id
1381: , registrant_contact_id
1382: , attendant_party_id
1383: , attendant_contact_id
1384: FROM ams_event_registrations
1385: WHERE event_offer_id = event_id_in
1386: AND system_status_code = 'REGISTERED' -- In future when we kill the REGISTERED status and leave ENROLLED, change this to ENROLLED.
1387: AND attended_flag = 'Y'
1388: AND active_flag = 'Y';

Line 1410: FROM ams_event_registrations reg,

1406: -- soagrawa 05-feb-2003 bug# 2787303
1407: CURSOR c_get_reg_att_for_lead (event_id_in IN NUMBER) IS
1408: SELECT reg.registrant_party_id party_id
1409: , reg.registrant_contact_id contact_id
1410: FROM ams_event_registrations reg,
1411: ams_event_offers_all_b event
1412: WHERE reg.event_offer_id = event_id_in
1413: AND reg.system_status_code = 'REGISTERED' -- In future when we kill the REGISTERED status and leave ENROLLED, change this to ENROLLED.
1414: AND reg.active_flag = 'Y'

Line 1420: FROM ams_event_registrations reg,

1416: AND event.create_registrant_lead_flag = 'Y'
1417: UNION
1418: SELECT reg.attendant_party_id party_id
1419: , reg.attendant_contact_id contact_id
1420: FROM ams_event_registrations reg,
1421: ams_event_offers_all_b event
1422: WHERE reg.event_offer_id = event_id_in
1423: AND reg.system_status_code = 'REGISTERED' -- In future when we kill the REGISTERED status and leave ENROLLED, change this to ENROLLED.
1424: AND reg.active_flag = 'Y'

Line 1478: -- Pick up each record from ams_event_registrations for this event schedule.

1474: -- consolidated 2 separate cursors into 1 cursor
1475: /*
1476: IF l_reg_lead_flag = 'Y'
1477: THEN
1478: -- Pick up each record from ams_event_registrations for this event schedule.
1479: -- Create a lead record for the Registrant in Lead Import Interface table.
1480: -- Mark the record to say the the Lead is created for the Registrant.
1481:
1482: OPEN c_get_registrant_for_lead(p_event_id);

Line 1526: -- Pick up each record from ams_event_registrations for this event schedule where the enrollee has attended the event.

1522: END IF;
1523:
1524: IF l_atnd_lead_flag = 'Y'
1525: THEN
1526: -- Pick up each record from ams_event_registrations for this event schedule where the enrollee has attended the event.
1527: -- This is indicated by a flag : ATTENDED_FLAG in ams_event_registrations.
1528: -- Create a lead record for the Attendee in Lead Import Interface table.
1529: -- Mark the record to say the the Lead is created for the Attendee.
1530:

Line 1527: -- This is indicated by a flag : ATTENDED_FLAG in ams_event_registrations.

1523:
1524: IF l_atnd_lead_flag = 'Y'
1525: THEN
1526: -- Pick up each record from ams_event_registrations for this event schedule where the enrollee has attended the event.
1527: -- This is indicated by a flag : ATTENDED_FLAG in ams_event_registrations.
1528: -- Create a lead record for the Attendee in Lead Import Interface table.
1529: -- Mark the record to say the the Lead is created for the Attendee.
1530:
1531: OPEN c_get_attendant_for_lead(p_event_id);