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:
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: