APPS.XNP_SV_NETWORK$SMS_FE_MAP dependencies on XDP_FES

Line 54: (L_FET_FE_NAME XDP_FES.FULFILLMENT_ELEMENT_NAME%TYPE

50: );
51: FORM_VAL FORM_REC;
52:
53: TYPE NBT_REC IS RECORD
54: (L_FET_FE_NAME XDP_FES.FULFILLMENT_ELEMENT_NAME%TYPE
55: ,L_FEE_FE_TYPE XDP_FE_TYPES.FULFILLMENT_ELEMENT_TYPE%TYPE
56: ,L_FET_FETYPE_ID XDP_FES.FETYPE_ID%TYPE
57: );
58: NBT_VAL NBT_REC;

Line 56: ,L_FET_FETYPE_ID XDP_FES.FETYPE_ID%TYPE

52:
53: TYPE NBT_REC IS RECORD
54: (L_FET_FE_NAME XDP_FES.FULFILLMENT_ELEMENT_NAME%TYPE
55: ,L_FEE_FE_TYPE XDP_FE_TYPES.FULFILLMENT_ELEMENT_TYPE%TYPE
56: ,L_FET_FETYPE_ID XDP_FES.FETYPE_ID%TYPE
57: );
58: NBT_VAL NBT_REC;
59:
60: ZONE_SQL VARCHAR2(1300) := null;

Line 232: XDP_FES L_FET,

228: L_FEE.FULFILLMENT_ELEMENT_TYPE,
229: SFP.FEATURE_TYPE,
230: SFP.PROVISION_STATUS
231: FROM XNP_SV_SMS_FE_MAPS SFP,
232: XDP_FES L_FET,
233: XDP_FE_TYPES L_FEE';
234:
235: ZONE_SQL := ZONE_SQL || I_WHERE;
236: ZONE_SQL := ZONE_SQL || ' ORDER BY SFP.SV_SMS_ID';