APPS.AMS_EVENTOFFER_PVT dependencies on AMS_AGENDAS_B

Line 1650: FROM ams_agendas_b

1646: SELECT activity_resource_id, object_version_number
1647: FROM ams_act_resources
1648: WHERE arc_act_resource_used_by = 'SESSION'
1649: AND act_resource_used_by_id IN ( SELECT agenda_id
1650: FROM ams_agendas_b
1651: WHERE agenda_type = 'SESSION'
1652: AND active_flag = 'Y'
1653: AND parent_id IN ( SELECT agenda_id
1654: FROM ams_agendas_b

Line 1654: FROM ams_agendas_b

1650: FROM ams_agendas_b
1651: WHERE agenda_type = 'SESSION'
1652: AND active_flag = 'Y'
1653: AND parent_id IN ( SELECT agenda_id
1654: FROM ams_agendas_b
1655: WHERE parent_id = id_in ) );
1656:
1657: -- VMODUR Added 4371624
1658: CURSOR c_get_min_max_session_time(id_in IN NUMBER, type_in in VARCHAR2) IS

Line 1660: from ams_agendas_b s, ams_agendas_b h

1656:
1657: -- VMODUR Added 4371624
1658: CURSOR c_get_min_max_session_time(id_in IN NUMBER, type_in in VARCHAR2) IS
1659: select min(s.start_date_time), max(s.end_date_time)
1660: from ams_agendas_b s, ams_agendas_b h
1661: where s.agenda_type = 'SESSION'
1662: and s.active_flag = 'Y'
1663: and s.parent_id = h.agenda_id
1664: and h.parent_id = id_in

Line 2876: FROM ams_agendas_b

2872: AND DEFAULT_FLAG = 'Y')
2873: WHERE activity_resource_id IN (SELECT activity_resource_id
2874: FROM ams_act_resources
2875: WHERE act_resource_used_by_id IN ( SELECT agenda_id
2876: FROM ams_agendas_b
2877: WHERE parent_id IN (SELECT agenda_id
2878: FROM ams_agendas_b
2879: WHERE parent_id = l_evo_rec.event_offer_id)));
2880:

Line 2878: FROM ams_agendas_b

2874: FROM ams_act_resources
2875: WHERE act_resource_used_by_id IN ( SELECT agenda_id
2876: FROM ams_agendas_b
2877: WHERE parent_id IN (SELECT agenda_id
2878: FROM ams_agendas_b
2879: WHERE parent_id = l_evo_rec.event_offer_id)));
2880:
2881:
2882: END IF;

Line 4423: FROM ams_agendas_b

4419:
4420:
4421: CURSOR c_get_track_id(id_in in NUMBER) IS
4422: SELECT agenda_id
4423: FROM ams_agendas_b
4424: WHERE parent_id = id_in;
4425:
4426: CURSOR c_get_session_id(id_in in NUMBER) IS
4427: SELECT agenda_id

Line 4428: FROM ams_agendas_b

4424: WHERE parent_id = id_in;
4425:
4426: CURSOR c_get_session_id(id_in in NUMBER) IS
4427: SELECT agenda_id
4428: FROM ams_agendas_b
4429: WHERE parent_id = id_in;
4430:
4431:
4432: l_msg_data VARCHAR2(2000);

Line 4670: update ams_agendas_b

4666: WHILE c_get_track_id%FOUND LOOP
4667: OPEN c_get_session_id(l_track_id);
4668: fetch c_get_session_id into l_session_id;
4669: WHILE c_get_session_id%FOUND LOOP
4670: update ams_agendas_b
4671: set room_id = null
4672: ,object_version_number = object_version_number + 1
4673: where agenda_id = l_session_id;
4674: fetch c_get_session_id into l_session_id;

Line 4841: update ams_agendas_b

4837: WHILE c_get_track_id%FOUND LOOP
4838: OPEN c_get_session_id(l_track_id);
4839: fetch c_get_session_id into l_session_id;
4840: WHILE c_get_session_id%FOUND LOOP
4841: update ams_agendas_b
4842: set room_id = null
4843: ,object_version_number = object_version_number + 1
4844: where agenda_id = l_session_id;
4845: fetch c_get_session_id into l_session_id;