APPS.AHL_PP_MATERIALS_PVT dependencies on DUAL

Line 1605: INTO l_schedule_material_id FROM DUAL;

1601: END IF;
1602: --
1603: -- Get Sequence Number for schedule material ID
1604: SELECT ahl_schedule_materials_s.NEXTVAL
1605: INTO l_schedule_material_id FROM DUAL;
1606: --
1607: --
1608: IF G_DEBUG='Y' THEN
1609: AHL_DEBUG_PUB.debug( 'before interface flag:'||p_x_req_material_tbl(i).rt_oper_material_id);

Line 1809: FROM DUAL;

1805: --
1806: END IF; --Material id g_miss_num
1807: --
1808: SELECT AHL_WO_OPERATIONS_TXNS_S.NEXTVAL INTO l_wo_operation_txn_id
1809: FROM DUAL;
1810: --
1811: IF G_DEBUG='Y' THEN
1812: AHL_DEBUG_PUB.debug( 'before calling log record l_wo_operation_txn_id:'||l_wo_operation_txn_id);
1813: END IF;

Line 2402: FROM DUAL;

2398: p_x_req_material_tbl(i).workorder_operation_id := l_req_material_rec.workorder_operation_id;
2399: --
2400: --Call transaction log to create record ahl_wo_operations_txns
2401: SELECT AHL_WO_OPERATIONS_TXNS_S.NEXTVAL INTO l_wo_operation_txn_id
2402: FROM DUAL;
2403: --
2404: IF G_DEBUG='Y' THEN
2405: AHL_DEBUG_PUB.debug( 'before calling log record l_wo_operation_txn_id:'||l_wo_operation_txn_id);
2406: END IF;