APPS.XNP_SV_NETWORK$SMS_ORDER dependencies on XNP_SV_ORDER_MAPPINGS

Line 38: CURR_VAL XNP_SV_ORDER_MAPPINGS%ROWTYPE;

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

Line 174: FROM XNP_SV_ORDER_MAPPINGS SOG';

170:
171: ZONE_SQL := 'SELECT SOG.SV_ORDER_MAPPING_ID,
172: SOG.ORDER_ID,
173: SOG.WORKITEM_INSTANCE_ID
174: FROM XNP_SV_ORDER_MAPPINGS SOG';
175:
176: ZONE_SQL := ZONE_SQL || I_WHERE;
177: ZONE_SQL := ZONE_SQL || ' ORDER BY SOG.SV_SMS_ID,
178: SOG.SV_SOA_ID';