DBA Data[Home] [Help]

APPS.AMS_CPYUTILITY_PVT dependencies on AMS_EVENT_HEADERS_VL

Line 86: FROM ams_event_headers_vl

82: IS
83:
84: CURSOR c_eveh_name(p_event_header_id IN NUMBER) IS
85: SELECT event_header_name
86: FROM ams_event_headers_vl
87: WHERE event_header_id = p_event_header_id;
88:
89: -- PL/SQL Block
90:

Line 472: FROM AMS_EVENT_HEADERS_VL

468:
469: ELSIF p_arc_act_code = 'EVEH' THEN
470: SELECT active_to_date,active_from_date
471: INTO end_date,start_date
472: FROM AMS_EVENT_HEADERS_VL
473: WHERE event_header_id = p_activity_id;
474: l_number := (end_date - start_date);
475: END IF ;
476: