DBA Data[Home] [Help]

APPS.AMS_EVENT_OBJECTS_COPY_PVT dependencies on AMS_EVENT_HEADERS_VL

Line 40: FROM ams_event_headers_vl

36: -- PL/SQL Block
37: l_name VARCHAR2 (256);
38: CURSOR c_agenda_name(p_agenda_id IN NUMBER) IS
39: SELECT event_header_name
40: FROM ams_event_headers_vl
41: WHERE parent_event_header_id = p_agenda_id;
42:
43: BEGIN
44:

Line 119: FROM ams_event_headers_vl

115: l_copy_columns_table AMS_CpyUtility_PVT.copy_columns_table_type;
116:
117: CURSOR new_event_dates (l_new_event_header_id NUMBER) IS
118: SELECT ACTIVE_FROM_DATE, ACTIVE_TO_DATE
119: FROM ams_event_headers_vl
120: WHERE EVENT_HEADER_ID = l_new_event_header_id;
121:
122: l_event_new_start_date DATE;
123: l_event_new_end_date DATE;

Line 508: FROM ams_event_headers_vl

504: ,program_id
505: ,CREATE_ATTENDANT_LEAD_FLAG
506: ,CREATE_REGISTRANT_LEAD_FLAG
507: ,EVENT_PURPOSE_CODE
508: FROM ams_event_headers_vl
509: WHERE parent_event_header_id = p_src_act_id
510: AND event_level='SUB';
511: BEGIN
512: p_errcode := NULL;