APPS.FTE_LTL_LOADER dependencies on DUAL

Line 1146: FROM DUAL;

1142: LOOP
1143: -- Get a process id
1144: SELECT qp_process_id_s.NEXTVAL
1145: INTO l_process_id
1146: FROM DUAL;
1147:
1148: l_process_ids(l_process_ids.COUNT + 1) := l_process_id;
1149:
1150: FTE_BULKLOAD_PKG.g_load_id := l_process_id;

Line 1677: FROM DUAL;

1673:
1674: BEGIN
1675: SELECT QP_PROCESS_ID_S.NEXTVAL
1676: INTO x_process_ID
1677: FROM DUAL;
1678: EXCEPTION
1679: WHEN OTHERS THEN
1680: x_status := 2;
1681: x_error_msg := 'Unexpected error while performing select qp_process_id_s.nextval ' || sqlerrm;

Line 2049: SELECT fte_lanes_s.NEXTVAL INTO l_lane_id FROM DUAL;

2045: -- For each carrier, create a lane and its associated entities
2046: --+
2047: FOR k IN 1..p_carrier_ids.COUNT LOOP
2048:
2049: SELECT fte_lanes_s.NEXTVAL INTO l_lane_id FROM DUAL;
2050:
2051: -- FTE_LANE_COMMODITIES
2052: FOR m IN 1..p_category_ids.COUNT LOOP
2053: CM_LANE_ID(cm_lane_id.COUNT+1) := l_lane_id;