APPS.FTE_DELIVERY_ACTIVITY dependencies on DUAL

Line 44: select wsh_delivery_leg_activities_s.nextval into s_activity_id from dual;

40: s_activity_id NUMBER;
41:
42: BEGIN
43:
44: select wsh_delivery_leg_activities_s.nextval into s_activity_id from dual;
45:
46: insert into wsh_delivery_leg_activities
47: (ACTIVITY_ID, DELIVERY_LEG_ID, ACTIVITY_DATE, ACTIVITY_TYPE, CREATION_DATE, CREATED_BY,
48: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN,

Line 187: SELECT wsh_delivery_leg_activities_s.nextval into s_activity_id FROM DUAL;

183:
184:
185: FOR c_rec IN c_dlegs(p_trip_id) LOOP
186:
187: SELECT wsh_delivery_leg_activities_s.nextval into s_activity_id FROM DUAL;
188:
189: IF l_debug_on THEN
190: WSH_DEBUG_SV.logmsg(l_module_name,'Inserting',WSH_DEBUG_SV.C_EXCEP_LEVEL);
191: END IF;