APPS.XNP_SV_ORDERS$SOA_EVENTS dependencies on XNP_SV_EVENT_HISTORY

Line 39: CURR_VAL XNP_SV_EVENT_HISTORY%ROWTYPE;

35: LOV_FRAME constant varchar2(20) := null;
36: TF_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"';
37: DEF_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"';
38:
39: CURR_VAL XNP_SV_EVENT_HISTORY%ROWTYPE;
40:
41: TYPE FORM_REC IS RECORD
42: (SV_EVENT_HISTORY_ID VARCHAR2(8)
43: ,SV_SOA_ID VARCHAR2(8)

Line 209: FROM XNP_SV_EVENT_HISTORY SEY';

205: SEY.EVENT_CODE,
206: SEY.EVENT_TYPE,
207: SEY.EVENT_TIMESTAMP,
208: SEY.EVENT_CAUSE_CODE
209: FROM XNP_SV_EVENT_HISTORY SEY';
210:
211: ZONE_SQL := ZONE_SQL || I_WHERE;
212: ZONE_SQL := ZONE_SQL || ' ORDER BY SEY.SV_SOA_ID,
213: SEY.EVENT_CODE';