APPS.XNP_SV_ORDERS$SOA_ORDERS 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 173: FROM XNP_SV_ORDER_MAPPINGS SOG';

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